Eclipse Community Forums: BIRT

Home » Archived » BIRT » Numbering Rows(Numbering Rows by Group)

Mon, 01 March 2010 13:54

Eclipse User

I am using the row.__rownum data to populate the row numbers on a report however I want this to start over at 1 everytime the group changes. Is there a quick and easy way to do this?

Re: Numbering Rows [message #517749 is a reply to message #517706]

Mon, 01 March 2010 17:01

Eclipse User

Dave,

Here is an example using an aggregation element.
http://www.birt-exchange.org/devshare/designing-birt-reports /1169-group-row-count/#description

Jason

David Jewell wrote:
> I am using the row.__rownum data to populate the row numbers on a report
> however I want this to start over at 1 everytime the group changes. Is
> there a quick and easy way to do this?

Re: Numbering Rows [message #518502 is a reply to message #517706]

Thu, 04 March 2010 05:18

Eclipse User

I use a similar method. On the Table element under the Bindings tab, I add an aggregation using data type integer, function RUNNINGCOUNT, pick any field, aggregate on the group that I want to have counts restart for.

For that matter, I defined a style that does alternate row coloring based on this column, which I name "fakerownumber" in all my reports.

Re: Numbering Rows [message #896463 is a reply to message #517749]

Wed, 18 July 2012 09:03

Eclipse User

this link is dead Sad

... anywhere else ?

Jason Weathersby wrote on Mon, 01 March 2010 17:01

Dave,

Here is an example using an aggregation element.
....

Jason

David Jewell wrote:
> I am using the row.__rownum data to populate the row numbers on a report
> however I want this to start over at 1 everytime the group changes. Is
> there a quick and easy way to do this?

Re: Numbering Rows [message #896570 is a reply to message #896463]

Wed, 18 July 2012 19:50

Eclipse User

Can you try:
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1169-group-row-count/

Jason

On 7/18/2012 9:03 AM, Ingoos Ficher wrote:
> this link is dead :( ... anywhere else ?
>
> Jason Weathersby wrote on Mon, 01 March 2010 17:01
>> Dave,
>>
>> Here is an example using an aggregation element.
>> ....
>>
>> Jason
>>
>> David Jewell wrote:
>> > I am using the row.__rownum data to populate the row numbers on a
>> report > however I want this to start over at 1 everytime the group
>> changes. Is > there a quick and easy way to do this?
>
>

Re: Numbering Rows [message #896622 is a reply to message #896570]

Thu, 19 July 2012 03:41

Eclipse User

tnx

... very helpful Smile

Jason Weathersby wrote on Wed, 18 July 2012 19:50

Can you try:
...

Jason

On 7/18/2012 9:03 AM, Ingoos Ficher wrote:
> this link is dead ... anywhere else ?
>
> Jason Weathersby wrote on Mon, 01 March 2010 17:01
>> Dave,
>>
>> Here is an example using an aggregation element.
>> ....
>>
>> Jason
>>
>> David Jewell wrote:
>> > I am using the row.__rownum data to populate the row numbers on a
>> report > however I want this to start over at 1 everytime the group
>> changes. Is > there a quick and easy way to do this?
>
>

Previous Topic:	Deploying BIRT application to Geronimo 3.0
Next Topic:	Report eating memory in viewer

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 26 16:37:17 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter