Suppress if Duplicated formating option 1

[arodri]

Hello,

I'm using Crystal Reports XI, and I'm having what I hope is a simply enough problem with formatting. I have a pretty basic report, with the names of employees, and the counts of products that they've sold. I have three headers: Region(GH#1), SiteName (GH#2), and EmplyeeName (GH#3). Here is a sample of what the report currently looks like:

Texas Prod1 Prod2
___________________________________
Dallas1 Jane Smith 105 25
Dallas1 James Lopez 89 0
Dallas1 Henry Smith 28 16
Dallas1 Mary Oliver 39 89

I need the sitename (Dallas1) to be in GroupFooter#3(EmployeeName) because I need it to show up NEXT to the employee Name (not above it, that's why I can't put it in GH#2), but I don't want it to repeat. I only want it to show up once. So I need the report to look like:

Texas Prod1 Prod2
___________________________________
Dallas1 Jane Smith 105 25
James Lopez 89 0
Henry Smith 28 16
Mary Oliver 39 89



Thanks for any help/suggestions!

 

[lbass]

You could leave it in a sitename group header and then format the group header section to "underlay following section".

"Suppress if duplicated" doesn't work in group headers.

-LB

 

[arodri]

Yeah I tried the "Suppress if duplicated" option first and it didn't seem to do anything.

Your suggestion worked perfectly - Thank you!