Refer to record number of a printed record?

[gslim]

Hi,

I need to refer to a pass record's row number, for eg in the report:

No Field1 Field2
1 XXX YYY
2 AAA BBB
3 CCC DDD refer to 1

I can't predetermine the record number as it depends on run-time table selection. Pls help.

Thanks
Gina

 

[Ngolem]

I don't see any relationship between the data in No. 1 and No. 3...how do you know that No. 3 refers to No. 1 and what do you want to do with the reference?

 

[gslim]

Ngolem,

Thank for your help. In fact there will be a third field in No.3 that points to 'XXX' value. However, in joining the records will still not give me the displayed record number.

The reason I want to do this is there are many records in the report, and it will be more precise to point to the record number than having the reader search for 'XXX'.

Thanks again!

Gina

 

[Ngolem]

I think what you want is doable but you will have to give a lot more details if you want an answer...

one problem with Crystal is that there is only one pass through the records...you cannot check back on something unless you save the info in an array and loop through it.

It may be possible to do something "WhileReadingRecords" and have another formula doing something
"WhilePrintingRecords"...but so far I cannot suggest anything because there are pieces to this puzzle missing

Jim