Group-wise record ids...in CR9

[busybeetle]

Hi!I want a group-wise running serial number generated. How do I go about doing this in Crystal report 9. An example of the scenario suppose for a set of records from a table X are linked to a set of records in table Y. The query would return all the child records for a given group (group-wise). Now, the serial number for the same have to be generated in cr9.

Thanks

 

[synapsevampire]

Depends on what you want in a serial number.

A sensible approach is to save serial numbers to a table somewhere, allowing for matching orders to the S/N, so this would mean creating a Stored Procedure.

You also have a few other means available:

You can use the record number in conjunction with the datetime:

totext(year(currentdatetime),0,"&quot+totext(month(currentdatetime))+totext(day(currentdatetime))+totext(
hour(currentdatetime))+totext(minute(currentdatetime))+totext(second(currentdatetime)
)+totext(recordnumber,0,"&quot

-k