Shaded Group Header Displays Across Entire Page

Posted on 2006-04-10
Medium Priority
Last Modified: 2006-11-18
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.

Question by:Denver930
  • 2

Accepted Solution

janmarini earned 300 total points
ID: 16423717
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.


Author Comment

ID: 16427047
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

LVL 101

Expert Comment

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


Author Comment

ID: 16445400

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

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question