I have a report that counts "problem units". I then have a subreport that counts the number of units manufactured of each type. The problem units are grouped by type, and the subreport runs for each group. I am using a shared variable to pass the result from the subreport to the main report. I then calculate the percentage of problem units to manufactured units and print the result in the group footer. I have another group footer in which I add up the problem units for all types in each product line and add up the units manufactured in the same manner. I calculate the percent of problem units to manufactured units from the two results and present the percentage in the outer group footer.
My boss would like to see this report sorted top down on this field for both groups. Since this field (report object) is not a standard summary, it does not appear in the drop list in the top down report expert.
Can this be done? If so, how?
A search of the forum produced a similar question asked about two years ago, but was apparently never answered.
Thanks in advance,
Marty
My boss would like to see this report sorted top down on this field for both groups. Since this field (report object) is not a standard summary, it does not appear in the drop list in the top down report expert.
Can this be done? If so, how?
A search of the forum produced a similar question asked about two years ago, but was apparently never answered.
Thanks in advance,
Marty