Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Don't waste time grieving over past mistakes. Learn from them and move on
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

17
May

How Do I Create a Gradient Shaded Background Report in Crystal Reports 2008?

A client recently asked me I how do I create a gradient shaded background effect to a report, using Crystal Reports 2008?


Solution

To create this gradient shade effect one has to use the Color function, which determines the Red Green and Blue constants of the colour, and a loop to increase the value, as one moves down the report.

To create a shaded gradient report background:
  1. Create a formula field called Details Colour

  2. Add the following formula:

    3. WhilePrintingRecords;
    NumberVar Colour;
    If Colour + 4 >= 255
    Then Colour := 0
    Else Colour := Colour + 4;

  3. Add the Details Colour formula field to the Details section of the report

  4. Select the formula field and suppress it

  5. Create  a formula field called Header Colour

  6. Add the following formula:

    7. WhilePrintingRecords;
    NumberVar Colour :=0;

  7. Add to the Header Colour formula field to the Page Header Section

  8. Select the Header Colour formula field and suppress it

  9. From the Report Menu select the Section Expert option

  10. In the Section Expert dialog box, select the Page Header Section

  11. Click on the Color Tab

  12. Press the [x + 2] button of the Background Colour option

  13. Enter the following formula:

    14. NumberVar Colour;
    RGB (Colour,255,255);

  14. Press the Save and Close button

  15. select the Details Section

  16. Press the [x + 2] button of the Background Colour option

  17. Enter the following formula:

    18. NumberVar Colour;
    RGB (Colour,255,255);

  18. Press the Save and Close button


If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us
1

Jeniffer Gonzalez

13
September
Como puedo hacer para combinar la gama de colores de acuerdo a mi criterio usando la función Color(Red, Green, Blue) Agradezco la ayuda.

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

26 + 28 =