Python String or boolean in Crystal Reports - How to format headings in report

167 Views Asked by At

I am not very good at python but it seems I need to alter a python string to get the results I need but I am not sure how to do it. In crystal reports I can color this section using the section expert but then it colors all the main headings the same color. For example I have this:

    If {@GroupNumber} = 1 then "prepress" 
   else 
    if {@GroupNumber} = 2 then "stock" 
   else 
   if {@GroupNumber} = 3 then "press" 
   else 
   if {@GroupNumber} = 4 then "ink" 
   else 
   if {@GroupNumber} = 5 then "postpress" 

Those are the different "groups" all utilizing the same header. It gives each section a different title but I need to find a way to specify each header in a different color. Any suggestions how I can get these headers color-coded?


if GroupNumber = 1 then fuchsia
else
If GroupNumber = 2 then yellow
else
If GroupNumber = 3 then yellow
else
If GroupNumber = 4 then yellow
else
If GroupNumber = 5 then green

Only my "press" heading is showing correct results. All the others are showing up black and I am not sure why.

1

There are 1 best solutions below

0
heringer On

For futher reference:

After the comments above, it seems the solution was to use the custom formula "{@GroupNumber}" instead of the reserved word "GroupNumber".

Though they have the same name, they refer to different things.