Focal Point
visualize

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5041051012

January 29, 2007, 05:18 AM
FrankDutch
visualize
I want to visualize some numbers in a report, but would like to give the graphs other colors than the available ones.
How can that be done?
I tried GRAPHCOLOR=RGB(0 75 130) but that gives an error.
Any suggestions?




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

January 29, 2007, 08:12 AM
Tony A
Same on 7.1.3 when format is HTML. OK in PDF though.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
January 29, 2007, 08:27 AM
FrankDutch
Sorry Tony
I do not understand the answer.

But what I tried to do was change a gif file in the vis directory. That is not the best solution sinc now my color "olive" gifs me the desired color. I would however add some company colors to the directorie instead of change them and also these new added colors should be in my list.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

January 29, 2007, 08:32 AM
mgrackin
Frank,

Here's something to try. There is a standard list of color names that can be used in the GRAPHCOLOR statement listed on page 29-31 of the Creating Reports manual. When creating the HTML results, the name is translated into the hex value for that color. The hex value is then used to create the name of the GIF file that is then used in the HTML. For example, GRAPHCOLOR=AQUA creates the following IMAGE tag in the HTML output:

<IMG SRC="/ibi_html/vis/g00ffff.gif" ...>

Here's what you do. Pick a color name you never use such as AQUA. Edit the GIF file in the ibi_html/vis directory with an image editor program and change the color of the image to whatever you want. Now everytime you reference AQUA you will see the custom color instead. I used Windows Paint program to change the gif color and it works.

THIS ONLY WORKS FOR HTML. Use the GRAPHCOLOR=RGB(0 75 130) statement for PDF output.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
January 29, 2007, 08:40 AM
mgrackin
Frank,

Susannah wrote an article about doing this and much more which is avaialble in the Focus on Developers section of Focal Point at:

http://www.informationbuilders.com/support/developers/GRAPHTYPE.html

Susannah did a very nice job with this article and it could be useful to you since she explains a better way than editing the GIF files.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
January 29, 2007, 08:42 AM
Tony A
Frank,

I was merely stating that with HTML output in 7.1.3 I got the same error as you, but when specifying PDF output then I had the required results Smiler

I would agree with Mickey on the method, use the document that Susannah wrote in the Focus on Developers section. Good stuff!!

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
January 29, 2007, 08:44 AM
mgrackin
Tony,

Ironically, the manual I have (7.1) does not say you can use RGB for PDF output. Do you have a more recent Creating Reports manual that documents using the RGB for PDF output?


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
January 29, 2007, 08:57 AM
Tony A
Hi Mickey,

No just the "suck it and see" manual approach Smiler lol

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
January 29, 2007, 10:20 AM
susannah
Good One




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
January 29, 2007, 11:02 AM
FrankDutch
Susannah
I found your document, it's great.

Mickey
what you suggested was what I did, but I wondered if you would not be able to add an extra gif file that can have the name "company_color1" and is visible in the selction list

Tony
I will give the different way of PDF and HTML a try.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7