VFP9 Report with Color

[grewegreg]

My question is this, I have a table with a field (ColorCode) that I am storing an RGB color code (stored as "RGB(255,0,255)"). Is there any way to get VFP9 SP1 to print a text field in a label or report, USING the RGB value that is stored in the ColorCode field?

I have made several different attempts to do this, but I keep coming back to the ugly solution of creating a text field for each color and using the "print when" condition to print the appropriate color. Anyone have any ideas? I could hack the FRX file, but that would make every field be that color and I really need it to be dynamic.

Too bad there is no "DynamicBackColor" in the reports. Where is VFP 10 when you need it???

I am glad to see the Search capability has been restored!




Greg Grewe
Diamond Consulting, LLC

http://www.diamondconsults.com

 

[ilyad]

I apologize in advance for giving a reference to another forum with a solution

http://www.universalthread.com/wconnect/wc.dll?2,41,17,1182383#1182790

 

[Mike Lewis]

Greg,

It should be possible to do this by writing a report listener, but I'm afraid I can't give you any details. I've never tried to do anything like that myself. I hope someone else can tell you.

Ilyad,

I apologize in advance for giving a reference to another forum with a solution

No need to apologise. It's perfectly legitimate to refer to other forums if they provide a valid answer to a question.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[grewegreg]

Thanks Ilyad, the solution from Don Rapp using the Listener will do the trick. Thanks much and have a nice weekend.


Greg Grewe
Diamond Consulting, LLC

http://www.diamondconsults.com

 

[ilyad]

I think it's not Friday yet You're welcome.