Shaded Group Header Displays Across Entire Page

I have a report that I used in Crystal 8.5. In that report I shaded two of the group headers. The shading stops at the right edge of the last field on the report.

When I bring up the report in CRXI, the shading now extends the full length of the page - that is the shading extends beyond the last field. When I export the report to Excel, the shading extends over all 256 columns.

The question: in CRXI, how do I restrict the group header shading so that it extends to the end of the fields in the report and not to the end of the page?

I am a beginning user in Crystal.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I don't have CRXI installed here so I can't take a look and try to reproduce your problem.  

But on CR 9.0 I provide shading to my headings within a box control.  If this is the same in CRXI, click on the box control to select it, right-click and select Size and Position - change the width property to something that you can see in your designer (try 7.5) and then modify it to reach the edge of your last field.  I f you have problems finding the control in the Heading, look under the Report explorer for something similar.

Let me know if you need more help.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Denver930Author Commented:
Thanks, Jan.

For those interested, In CRXI, the commands are Insert/Box. Then create and select the box. Next, right-click and select Format Box. Finally, check the Fill Color check box in the Format Editor and choose a color.

Your suggestion works . . . but, when the report is exported to Excel, the shading/color is lost.

The original technique - highlighting the header in Section Expert, selecting the Color tab, checking Background Color and finally, choosing a color - works but extends the shading to the right edge of the page. When exported to Excel, the header is shaded across all columns, not just the report data columns.

If no one else responds, I'll award you the points in a day or so. Thanks for showing me a new technique.

- Dennis

How are you exporting?  Are you exporting the data only or report format?

Denver930Author Commented:

File\Export\Export Report

Format: MS Excel 97-2000 (XLS)
Options: Column width based on objects in the: Whole Report
              Show gridlines option checked.

Thanks for your input.

- Dennis
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.