Eclipse Community Forums: BIRT » How can I enumerate row in group??

Home » Archived » BIRT » How can I enumerate row in group??

How can I enumerate row in group?? [message #250144]

Fri, 27 July 2007 05:52

Eclipse User

Re: How can I enumerate row in group?? [message #250148 is a reply to message #250144]

Fri, 27 July 2007 05:58

Eclipse User

Re: How can I enumerate row in group?? [message #250175 is a reply to message #250148]

Fri, 27 July 2007 11:21

Eclipse User

Dexiu ha scritto:
> Dexiu pisze:
>> I have report where i must do this:
>>
>> group 1
>>
>> index | content of row
>> -------------------------
>> 1 | abcd
>> 2 | asdf
>> 3 | aser
>>
>> group 2
>>
>> index | content of row
>> -------------------------
>> 1 | fret
>> 2 | hrth
>> 3 | kkff
>>
>> Sebastian Nowak
> How can i do this??
>
> Sebastian Nowak

Hi!

Add a data field in your table and select RowNum from available
columns binding.

row.__rownum will appear in the expression.

Remember that RowNum starts counting from 0 (zero).
So you'll write row.__rownum+1

Easy, right ? :)

Bye
Nico

Re: How can I enumerate row in group?? [message #250312 is a reply to message #250175]

Mon, 30 July 2007 03:05

Eclipse User

Originally posted by: dexiu.dexiu.pl

Nico pisze:
> Dexiu ha scritto:
>> Dexiu pisze:
>>> I have report where i must do this:
>>>
>>> group 1
>>>
>>> index | content of row
>>> -------------------------
>>> 1 | abcd
>>> 2 | asdf
>>> 3 | aser
>>>
>>> group 2
>>>
>>> index | content of row
>>> -------------------------
>>> 1 | fret
>>> 2 | hrth
>>> 3 | kkff
>>>
>>> Sebastian Nowak
>> How can i do this??
>>
>> Sebastian Nowak
>
>
> Hi!
>
> Add a data field in your table and select RowNum from available
> columns binding.
>
> row.__rownum will appear in the expression.
>
>
> Remember that RowNum starts counting from 0 (zero).
> So you'll write row.__rownum+1
>
> Easy, right ? :)
>
> Bye
> Nico
Hi, it's not so easy
row.__rownum+1 return

group 1

index | content of row
-------------------------
1 | abcd
2 | asdf
3 | aser

group 2

index | content of row
-------------------------
4 | fret
5 | hrth
6 | kkff

Re: How can I enumerate row in group?? [message #250325 is a reply to message #250312]

Mon, 30 July 2007 04:20

Eclipse User

Hi Dexiu

The row.__rownum is the index of all row of table, currently it can not
define index based on group. You can try these way:

1, Drag a aggregation from palette into your table to instead of index
column.
2, Select the Data field to "content of row" column
3, Select the function to RUNNINGCOUNT
4, Select Aggregation on Group you defined in table.

I hope that will fill your need.

Regards!

Re: How can I enumerate row in group?? [message #250328 is a reply to message #250312]

Mon, 30 July 2007 04:24

Eclipse User

Hi Dexiu

I attached the report design file, that file may help you to solve that.

Regards!
Tianli

"Dexiu" <dexiu@dexiu.pl> wrote in message
news:f8k2j0$u2o$1@build.eclipse.org...
> Nico pisze:
>> Dexiu ha scritto:
>>> Dexiu pisze:
>>>> I have report where i must do this:
>>>>
>>>> group 1
>>>>
>>>> index | content of row
>>>> -------------------------
>>>> 1 | abcd
>>>> 2 | asdf
>>>> 3 | aser
>>>>
>>>> group 2
>>>>
>>>> index | content of row
>>>> -------------------------
>>>> 1 | fret
>>>> 2 | hrth
>>>> 3 | kkff
>>>>
>>>> Sebastian Nowak
>>> How can i do this??
>>>
>>> Sebastian Nowak
>>
>>
>> Hi!
>>
>> Add a data field in your table and select RowNum from available
>> columns binding.
>>
>> row.__rownum will appear in the expression.
>>
>>
>> Remember that RowNum starts counting from 0 (zero).
>> So you'll write row.__rownum+1
>>
>> Easy, right ? :)
>>
>> Bye
>> Nico
> Hi, it's not so easy
> row.__rownum+1 return
>
> group 1
>
> index | content of row
> -------------------------
> 1 | abcd
> 2 | asdf
> 3 | aser
>
> group 2
>
> index | content of row
> -------------------------
> 4 | fret
> 5 | hrth
> 6 | kkff

Attachment: rownumber.rptdesign
(Size: 29.50KB, Downloaded 342 times)

Re: How can I enumerate row in group?? [message #250366 is a reply to message #250325]

Mon, 30 July 2007 08:12

Eclipse User

Originally posted by: dexiu.dexiu.pl

Tianli pisze:
> Hi Dexiu
>
> The row.__rownum is the index of all row of table, currently it can not
> define index based on group. You can try these way:
>
> 1, Drag a aggregation from palette into your table to instead of index
> column.
> 2, Select the Data field to "content of row" column
> 3, Select the function to RUNNINGCOUNT
> 4, Select Aggregation on Group you defined in table.
>
> I hope that will fill your need.
>
> Regards!
>
>
RUNNINGCOUNT - I don't have this function :( or I can't find...

Re: How can I enumerate row in group?? [message #250467 is a reply to message #250366]

Mon, 30 July 2007 20:33

Eclipse User

Hi Dexiu

Have you seen the report design I attached? The normal dataitem has no
function list, you should use the Aggregation, it's in Palette's Quick
Tools.
It can count your row based on group of table or the whole table.

Regards!

Previous Topic:	Algum Brazuca na lista !???
Next Topic:	Image generation

Goto Forum:

-=] Back to Top [=-

Current Time: Thu May 01 12:44:39 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter