0

CRYSTAL REPORTS

Dear All,

I make my crystal report and i got problem to get red or yelow color for lines what are fail or ghiger than 70%.

In fild tolerance i got in some lines so big numbers that they can t be visible?

 

Any coments how to solve this problems.

 

See attachment!

 

Best regards!

7 comments

Date Votes
1
Avatar
Srdjan Calija

attachment

Attachment not imported: crystal_reports.jpg
0
Avatar
Joakim Spångberg

There are people here that are far better at Crystal Reports then me, but I'll try to help as much as I can.

 

First, do you use a premade report or a custom one you've made yourself?

I do not think the premade ones have colour coding built in them. I assume you mean like the colours you get in the MET/CAL Run Time Test Results window.

As for the issue with that large numbers are not visible. It is because each field have a specified width. Which means that only a certain ammount of digits can fit. To solve this you need to edit the report and increase the width of the field.

 

I hope it helps.

0
Avatar
Srdjan Calija

Dear Joakim,

I made this report.

Color report I find in met track base (see attachment)!

Maybe to use this report and there make changes?

 

Best regards!

Attachment not imported: crystal_reports_color.jpg
0
Avatar
Joakim Spångberg

I am assuming the crystal_reports_color.jpg is a screen of the rt_report_of_cal_ver_7_color_coded.rpt. I only made a quick glance at it but it seems it is the field Ver_7_Certificates.remark that adds the colour.

0
Avatar
David Weir-Marshall

If you've got a report "Results MC 7.2" take a look in there. I believe it's one of the sample reports.

It has a formula for colour coding.

 

Otherwise you want to create a Formatting Formula to set the background colour.

Something like the following:

// If condition equals "Notify User"
If {Ver_7_Certificates.test_status} = "Notify User"
    // Then print background color Red
    Then crRed
        else crNoColor

 

0
Avatar
Joakim Spångberg

I had some spare time yesterday so I made a another look at it.

You need to creat a formating formula to set the background colour for the Detail section. Just as MetMonkey writes.

 

The formula in the sample reports is:

// If condition equals "Notify User"
If {Ver_7_Certificates.condition} = "Notify User"
    // Then print background color Red
    Then crRed
    // If not "Notify User" check for next condition
    Else
    // If condition equals "Marginal"
    IF {Ver_7_Certificates.condition} = "Marginal"
        // Then print background color Yellow
        Then crYellow
        // Else print with no color
        Else crNoColor

        
// This color scheme was chosen based on the conditions that exist in the Runtime window
//   With the exception of the Green if Pass.  No color was chosen for this to save
//   ink in the printer.

// If you wish to print green on the "PASS" condition
// change 'crNoColor' to 'crGreen'
 

0
Avatar
Srdjan Calija

Thank you very much for help!!!!

Please sign in to leave a comment.