I have a report that contains the following (healthcare) data:

 

Podcode

Medications Adminstered

Medications Scanned (a portion of above)

Medications Manual (the rest of Medicationas Administered that were not Scanned)

 

plus some detail information

 

The user wants the report to be:

 

A summary level per Podcode organized by the % of medications scanned (Medications Scanned/Medications Administered)

 

This is easy enough to do - create a formula and group by that formula. So it will say somethings like

 

Podcode    %Scanned

 

B17           89.3%

A02           87.9%

D12           86.2%

 

etc.

 

Here's the problem. When you drill down to the detail information a tab appears on the report. On the tab is what you are grouping by - the % Scanned in this case. So for the first row the tab will say 89.3%. The user would like for it to say the Podcode, B17, because that is known and familiar to the user.

 

I couldn't find a way to do this. Can it be done?

 

Thanks,

 

Dick Rosenberg

 

I figured it out myself. In the Report/Group Expert/Option/Options box (labeled Change Group Options) there is a place to display another column other than the one you grouped by. I just clicked on the Podcode and it showed up just the way I wanted.

 

Thanks,

 

Dick