Report Footnotes

I have a complex report that I am currently doing on a batch basis using Pro*C 2.2.3 in Unix. What I would like to do is to move it into the client-server arena using Dev. 2000 Reports 2.5. Here is the tricky part:

Many different fields can have footnotes attached to them. Although these footnotes are assigned numbers, which can then be looked up in a table, the report will show the footnote as a sequential letter, i.e., the first footnote, although it may be 327, will be labeled 'A', the second footnote, although it may be 7, will be labeled 'B', and so on. If a footnote repeats, say footnote 7 ('B'), it will, of course, be referred to as 'B' again.

In the batch program I am populating a temporary table with the footnote number and its corresponding sequential letter reference. Everytime a new footnote is encountered, it is looked up in the temporary table. If it has been used before, the same letter reference is used; if it is new, than the next sequential letter is assigned to it. After the detail report prints all the data with any footnotes found, the batch program prints out the footnotes and their descriptions (really they are end notes rather than footnotes).

I want to be able to do the same thing using the Report Writer that I currently am doing in the batch program. Can anyone think of a way? Thanks for any help. Received on Mon Jan 05 1998 - 00:00:00 CET