Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Conditional background for report field
Message
From
28/09/2020 12:50:12
 
 
To
26/09/2020 06:39:25
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01676243
Message ID:
01676293
Views:
74
Hi Ken,

In this case, I want the *value* of the field to print every time - I just want the background of the value to change depending upon the value in the field. For example, if the value is negative, I want to have a red background; if it is zero or positive, I want it to have a white background.

I was trying to do this via the "Dynamics" tab by specifying a condition there to dynamically change the background - but reading the help file further, I have a feeling that this is only evaluated once for the overall report, not on every detail line in the report. Can someone confirm this? And if this is so, is there a way to maybe force it to be re-evaluated for each detail row?

Thanks,
Albert

>>Hi all,
>>
>>Is there a way to conditionally change the background on a report field in a report? In this case, the user wants empty values to be shaded red on the report so that they stand out. I know I can do this with a shaded box that overlays the field and put my condition in the Print When field. But this is tedious work to overlay these boxes on a report. It seems as though the Dynamics tab on a field should work but so far have not got the right set of combinations for it to work.
>>
>>I have a) added a Condition under Dynamics, then:
>>- filled in the condition for "Apply when..."
>>- chose Opaque
>>- chose my fill colour
>>
>>see attached sample
>I suggest you use the PrintWhen option of that textbox.
>Stay healthy,
>Koen
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform