Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing Selection Criteria on a report. 2

Status
Not open for further replies.

mrshardee2

Technical User
May 24, 2004
29
US
I have a report in Crystal 8.5 that shows Anesthesia Types selected by Anesthesiologist, OR Suite, Patient Type, etc. I would like to show in the footer of the report the criteria that the user selects to print the report. The only parameter that I can get to print on the report is the Beginning Date and the Ending Date. Everything else prints blank, even though the data is showing (so I know the parameters are working to select data).

Thanks!


Amber [peace]
 
Sorry, I misled you--wasn't thinking. Use this formula in the details section:

whileprintingrecords;
stringvar names;

if instr(names,{psmresindstaff.res_abbr}) = 0 then
names := names + {psmresindstaff.res_abbr} + ", " else
names := names;

Then in the report footer, use this:
whileprintingrecords;
stringvar names;
left(names,len(names)-2);

But, as I said earlier, unless you only have a few practitioners, you will get an error re: the formula exceeds the 254 string length...

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top