Shaded Group Header Displays Across Entire Page

Posted on 2006-04-10
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
    LVL 7

    Accepted Solution

    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

    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 100

    Expert Comment

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


    Author Comment


    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    This video discusses moving either the default database or any database to a new volume.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now