Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
visualize
 Login/Join
 
Virtuoso
posted
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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Expert
posted Hide Post
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 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Virtuoso
posted Hide Post
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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
Expert
posted Hide Post
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 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
Expert
posted Hide Post
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 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
Good One




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Virtuoso
posted Hide Post
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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders