nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

A new rownum for each id

Ulf

Hello there, 
 
I? m a bit curious about a few issues in my report in BIRT. 
I?ve written a stored procedure, which includes an amount of data in my database. 
The id has several datasets included. A row number (__rownums) has to count the rows of the tables of the databases until the id is changing. 
Then the next id should do the same, should start at 1 as well and counts its datasets. 
 
I would be really relieved if someone could help me as soon as possible. 
 
Best regards 
 
Ulf

Find more posts tagged with

Comments

mwilliams

I'm not sure I'm completely following the question. You want to be able to do counts like this within your BIRT report? If so, you should be able to use a computed column in your dataSet or you could use aggregations and grouping within your report to create a running count.

ceefour

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="70319" data-time="1289840109" data-date="15 November 2010 - 09:55 AM">
I'm not sure I'm completely following the question. You want to be able to do counts like this within your BIRT report? If so, you should be able to use a computed column in your dataSet or you could use aggregations and grouping within your report to create a running count. </blockquote>
 
Thank you mwilliams. I'm not sure if that solves the TS's problem but your solution is exactly what I'm looking for: In the Table's Binding, I added a Aggregate Column Binding, then use RUNNINGCOUNT on the group I want. I get number starting from 1 that resets on each new group. Awesome!

mwilliams

Hi ceefour,

Glad the above thread helped your situation! Let us know whenever you have BIRT related questions!