Add counter to a dataset

[lindiwemaduna]

Hi Everyone,
I have populated a dataset from a view. I want to add a counter to each record in the dataset. I want to display the dataset in an active report with the counter. i am breaking by some field, this should also reset the counter at each break. how would i set the counter in the dataset?

[sandeepk84]

Hi Everyone,
I have populated a dataset from a view. I want to add a counter to each record in the dataset. I want to display the dataset in an active report with the counter. i am breaking by some field, this should also reset the counter at each break. how would i set the counter in the dataset?

hi...
have u tried it by using count(*)???

eg: select count(*),col1,c ol2,col3 from table_name;

but dis will give u incremented ctr at each row...without any break...

hope dis helps...
thanx and rgrds..
sand...

[jaketrimble]

Hi Everyone,
I have populated a dataset from a view. I want to add a counter to each record in the dataset. I want to display the dataset in an active report with the counter. i am breaking by some field, this should also reset the counter at each break. how would i set the counter in the dataset?

Hey!
unfortunately this is not a short answer...so before I send you the answer, can you please send an example of what you have for this so far to include any HTML? and I will send you and example of what you need to do.

Basically, at ItemDatabound, we will designate which rows contain the counter, then we will apply some style attributes to those rows, thus breaking them up nicely!