Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Numbering Rows(Numbering Rows by Group)
Numbering Rows [message #517706] Mon, 01 March 2010 18:54 Go to next message
David Jewell is currently offline David JewellFriend
Messages: 12
Registered: February 2010
Junior Member
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 22:01 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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 10:18 Go to previous messageGo to next message
Richard A. Polunsky is currently offline Richard A. PolunskyFriend
Messages: 212
Registered: July 2009
Location: Houston TX
Senior Member

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 13:03 Go to previous messageGo to next message
Ingoos Ficher is currently offline Ingoos FicherFriend
Messages: 5
Registered: July 2012
Junior Member
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 23:50 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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 07:41 Go to previous message
Ingoos Ficher is currently offline Ingoos FicherFriend
Messages: 5
Registered: July 2012
Junior Member
tnx Smile ... 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 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?
>
>

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


Current Time: Thu Mar 28 14:48:53 GMT 2024

Powered by FUDForum. Page generated in 0.03610 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top