Printing multiple copies with name suppress

[victora]

Hi all,
I have an unusual report request. Theres a table that contains the number of ER visits. So it has the doctor's name and ER count. Say I have 50 doctors in the Internal Medicine group. I want to print the report 50 times showing one doctor's name at a time but show everybody else ER count. I hope I made sense in my explanation...
This report will be mailed to the doctor shown on the report but he/she will not know/see the names of the other docs. This is sorted by ER count, so he/she can see her position on the report.

Thanks in advance.
victora

 

[lbass]

I think you could do this best with a main report that is grouped on {table.doctor} with the group footer set for new page after. Then insert an unlinked subreport that contains all doctors and place it in GH#1_b. The subreport should show all doctors' names and their corresponding counts in the detail section, sorted as you wish. In the main report create a formula:

//{@thisdoctor}:
whileprintingrecords;
shared stringvar thisdoc := {table.doctor};

Place this formula in GH#1_a and suppress it. In the subreport, highlight the doctor's name field->format field->common->suppress->x+2 and enter:

whileprintingrecords;
shared stringvar thisdoc;
{table.doctor} <> thisdoc

This should suppress the name except in the row that matches the group in the main report. If you wish, you can suppress the main report GH#1_a, and display only the subreport.

-LB

 

[victora]

thanks LB, that was fast response. I will take a shot at it and will post the result...

Again, thank you!

 

[victora]

LB,
WORKS LIKE A CHARM! Thanks lbass, you're the man!
10 stars to you!

VA