Hi there,

We have a cross tab report and the user is requesting line numbers to be added to the detail.
It is a report that is generated based on groups, so the counter needs to be reset per group.
Would it be easier to achieve this through the Stored Procedure (Data Source), or can this be easily done in Crystal?

Any help and steps on how to achieve this would be greatly appreciated!

Thank you.

(I inherited the code so I'm not sure how the process works, but let me know if more info is needed and I'll gladly supply it.)

Hi there,

Thanx for the reply!
I am not too familiar with Crystal, as I've only been working with it for 4 months, so please excuse me if I do not use the right terminology...

It is definitely a cross tab report, because we have a similar report (similar in the data, not the structure) and it works with grouping.  So, with that I used a running total to number the detail lines.  I need to achieve this for the cross tab report as well, but as you stated, it does not have detail lines, so I do not know how to generate the line numbers on the final report.
As a solution for the time being, I have changed the stored procedure to include the line numbers, instead of generating them in the report.

So, technically the problem is solved, but I would like to know whether or not this can be achieved in the cross tab report?

how can i reset the number within the groups. my cross tab is below the group

how can i sort the serial number ascending if i wanted to put the column total at the bottom