I have a report that collects data from a main table and several other tables with which the main table has a one-to-many relationship. This results in several rows in the result set for each record I wish to display in my Crystal Report. I use a group to consolidate the records into a single printed record.
Because this is a lengthy report, my client wants a "Record X of Y" counter at the bottom of the page. The built in special field gives me just that -- the individual record count; however, I need to display Group X of Y. Each record could span multiple pages, so Page X of Y won't do it for me, either. I found the Group Number field (gives me X), but how can I calculate the total number of groups in the report (thus giving me Y)?