Conditional Color in Detail Band

[kamweng]

I have just learnt how to use the VFP9 (SP1) Report Writer.
Now I wonder is it possible to have conditional foreground (pen) color in the Detail Band.

I have searched the FQA, help file and the KEYWORD "Detail Band", but could not find an answer.

I tried "IIF(dbr.tb <= 0, forecolor = RGB(255,0,0), forecolor = RGB(0,0,0))" in the format tab but failed.

Your guildance will be greatly appreciated. Thank you.

 

[JRB-Bldr]

Maybe someone else might have a better idea, but have you tried the following?

1. Place 2 textboxes in the Detail band to represent each of the items/values you want displayed.
2. Make the color properties of each the way you want them to be for the 2 different circumstances - that is make one with a RGB(0,0,0) foreground (font color) and the other with a RGB(255,0,0) foreground
3. Now use the Print When... expression to control which prints when -
One to Print When dbr.tb <= 0 and the other to Print When dbr.tb > 0
4. Physically move the textboxes so that for any given value the 2 textboxes fully physically over-laps the other - it should not matter which is on top or not.

That method has worked for me in the Report Form versions prior to VFP9 so I'm guessing that it will continue to work in VFP9

Good Luck,
JRB-Bldr

 

[Mike Lewis]

Maybe someone else might have a better idea, but have you tried the following?

I don't think you'll find a better method.

It's possible to do this sort of thing with a custom report listener, but it's complicated, and requires some knowledge of how report listeners work. The method that JRB suggested is the usual way of doing it.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[kamweng]

Thank you for your advice.

 

[Olaf Doschke]

In the Dynamics tab of the Field Poperties window you can add conditions, this works quite like a case statement. Name your condition, then set the conditions expression and set the pen foreground/background color as wanted. That's not giving you direct assignment of an rgb value from a field, but you can define 2,3,...N colors and activate each via some condition like balance<0 for red, balance= for white and balance>0 for black.

Bye, Olaf.

 

[Mike Lewis]

I forgot about the Dynamics tab. It was introduced in VFP 9.0 SP2 (I'm still on SP1.)

Kamweng, there's a discussion on this topic in thread184-1592433.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Mike Lewis]

And note that the Dynamic properties require SET REPORTBEHAVIOR 90.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[lardecristo]

I'm using Google Translator Solution for the VFP 9
kamweng, put an attachment here, but I'll explain what I did.

I created the report and put a Fields, right clicked and went in there and Dynamics created the conditions that I wanted, take a look when put something here.

 

[kamweng]

lardecristo, Thank you for your help but I could not open the exe because of the SetDefPr "Printer Device Name". My default printer is "EPSON ME 620F Series". Please untick the SAVE PRINTER ENVIRONMENT in the page setup. Thank you.