August 3, 200718 yr Is there a way to show the record number within a sub summary? I have created a report with this type of layout: Type A Company C, Avg: 5 Company B, Avg: 4.7 Company D, Avg: 3.2 Type B Company A, Avg 4.9 Company E, Avg 2.4 Type C ... ... The Type and Company are both sub summaries when sorted by Type and Company, respectively. I do not have a body; I wasn't interested in displaying each individual record, but they do drive the calculation for the Avg for each company. That report displays exactly how I wanted it, but now I would like to add a Company's "rank" by enumerating what order they show up inside each Type. So, I want the report to look like this: Type A 1 Company C, Avg: 5 2 Company B, Avg: 4.7 3 Company D, Avg: 3.2 Type B 1 Company A, Avg 4.9 2 Company E, Avg 2.4 Type C ... ... Any suggestions? Notice how i want it to reset after each Type sub summary... and also, there may be multiple records (though not displayed, since i'm not using a body) per each Company sub summary. I feel like this should be built-in, somewhere... but i can't seem to find out how to do it.
Create an account or sign in to comment