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.
Hey all, I have a global style sheet that we use at our organization that was built by a former IBI Consultant. The style sheet works great and the hover over piece also works great with all charts, unless it's a stacked percentage bar chart. They typical hover over shows as a black background with white text, but on the percentage chart, it comes up as a dark charcoal background and a grey and black text, so it's extremely hard to read.
I have attached our style sheet code, and I have played around with the rgb settings on the lines that contain HOVER, but nothing seems to work to get that percentage chart hover to mimic what it should be. Is this a common or known issue with the percentage chart? Is there a way to add some code to force a new HOVER color scheme inside the procedure even if I am referencing the global style sheet?
setGradientDirection(getSeries(0),3); setGradientPinLeftColor0(getSeries(0),new Color(100,171,218)); setGradientPinRightColor0(getSeries(0),new Color(100,171,218)); setGradientPinLeftColor2(getSeries(0),new Color(100,171,218)); setGradientPinRightColor2(getSeries(0),new Color(100,171,218)); setGradientPinLeftColor1(getSeries(0),new Color(100,171,218)); setGradientPinRightColor1(getSeries(0),new Color(100,171,218)); setGradientPinLeftColor0(getSeries(0), new Color(100,171,218,150)); setGradientPinRightColor0(getSeries(0), new Color(100,171,218,150)); setGradientPinLeftColor2(getSeries(0), new Color(100,171,218,150)); setGradientPinRightColor2(getSeries(0), new Color(100,171,218,150)); setGradientPinLeftColor1(getSeries(0), new Color(100,171,218,0)); setGradientPinRightColor1(getSeries(0), new Color(100,171,218,0)); setFillType(getSeries(0),4); setGradientPinLeftColor1(getSeries(0), new Color(100,171,218,210)); setGradientPinRightColor1(getSeries(0), new Color(100,171,218,210)); setGradientPinPosition0(getSeries(0),0.0); setGradientPinPosition1(getSeries(0),1.0); setGradientDirection(getSeries(1),3); setGradientPinLeftColor0(getSeries(1),new Color(152,35,113)); setGradientPinRightColor0(getSeries(1),new Color(152,35,113)); setGradientPinLeftColor2(getSeries(1),new Color(152,35,113)); setGradientPinRightColor2(getSeries(1),new Color(152,35,113)); setGradientPinLeftColor1(getSeries(1),new Color(152,35,113)); setGradientPinRightColor1(getSeries(1),new Color(152,35,113)); setGradientPinLeftColor0(getSeries(1), new Color(152,35,113,150)); setGradientPinRightColor0(getSeries(1), new Color(152,35,113,150)); setGradientPinLeftColor2(getSeries(1), new Color(152,35,113,150)); setGradientPinRightColor2(getSeries(1), new Color(152,35,113,150)); setGradientPinLeftColor1(getSeries(1), new Color(152,35,113,0)); setGradientPinRightColor1(getSeries(1), new Color(152,35,113,0)); setFillType(getSeries(1),4); setGradientPinLeftColor1(getSeries(1), new Color(152,35,113,210)); setGradientPinRightColor1(getSeries(1), new Color(152,35,113,210)); setGradientPinPosition0(getSeries(1),0.0); setGradientPinPosition1(getSeries(1),1.0); setGradientDirection(getSeries(2),3); setGradientPinLeftColor0(getSeries(2),new Color(138,186,87)); setGradientPinRightColor0(getSeries(2),new Color(138,186,87)); setGradientPinLeftColor2(getSeries(2),new Color(138,186,87)); setGradientPinRightColor2(getSeries(2),new Color(138,186,87)); setGradientPinLeftColor1(getSeries(2),new Color(138,186,87)); setGradientPinRightColor1(getSeries(2),new Color(138,186,87)); setGradientPinLeftColor0(getSeries(2), new Color(138,186,87,150)); setGradientPinRightColor0(getSeries(2), new Color(138,186,87,150)); setGradientPinLeftColor2(getSeries(2), new Color(138,186,87,150)); setGradientPinRightColor2(getSeries(2), new Color(138,186,87,150)); setGradientPinLeftColor1(getSeries(2), new Color(138,186,87,0)); setGradientPinRightColor1(getSeries(2), new Color(138,186,87,0)); setFillType(getSeries(2),4); setGradientPinLeftColor1(getSeries(2), new Color(138,186,87,210)); setGradientPinRightColor1(getSeries(2), new Color(138,186,87,210)); setGradientPinPosition0(getSeries(2),0.0); setGradientPinPosition1(getSeries(2),1.0); setGradientDirection(getSeries(3),3); setGradientPinLeftColor0(getSeries(3),new Color(255,96,26)); setGradientPinRightColor0(getSeries(3),new Color(255,96,26)); setGradientPinLeftColor2(getSeries(3),new Color(255,96,26)); setGradientPinRightColor2(getSeries(3),new Color(255,96,26)); setGradientPinLeftColor1(getSeries(3),new Color(255,96,26)); setGradientPinRightColor1(getSeries(3),new Color(255,96,26)); setGradientPinLeftColor0(getSeries(3), new Color(255,96,26,150)); setGradientPinRightColor0(getSeries(3), new Color(255,96,26,150)); setGradientPinLeftColor2(getSeries(3), new Color(255,96,26,150)); setGradientPinRightColor2(getSeries(3), new Color(255,96,26,150)); setGradientPinLeftColor1(getSeries(3), new Color(255,96,26,0)); setGradientPinRightColor1(getSeries(3), new Color(255,96,26,0)); setFillType(getSeries(3),4); setGradientPinLeftColor1(getSeries(3), new Color(255,96,26,210)); setGradientPinRightColor1(getSeries(3), new Color(255,96,26,210)); setGradientPinPosition0(getSeries(3),0.0); setGradientPinPosition1(getSeries(3),1.0); setGradientDirection(getSeries(4),3); setGradientPinLeftColor0(getSeries(4),new Color(20,188,204)); setGradientPinRightColor0(getSeries(4),new Color(20,188,204)); setGradientPinLeftColor2(getSeries(4),new Color(20,188,204)); setGradientPinRightColor2(getSeries(4),new Color(20,188,204)); setGradientPinLeftColor1(getSeries(4),new Color(20,188,204)); setGradientPinRightColor1(getSeries(4),new Color(20,188,204)); setGradientPinLeftColor0(getSeries(4), new Color(20,188,204,150)); setGradientPinRightColor0(getSeries(4), new Color(20,188,204,150)); setGradientPinLeftColor2(getSeries(4), new Color(20,188,204,150)); setGradientPinRightColor2(getSeries(4), new Color(20,188,204,150)); setGradientPinLeftColor1(getSeries(4), new Color(20,188,204,0)); setGradientPinRightColor1(getSeries(4), new Color(20,188,204,0)); setFillType(getSeries(4),4); setGradientPinLeftColor1(getSeries(4), new Color(20,188,204,210)); setGradientPinRightColor1(getSeries(4), new Color(20,188,204,210)); setGradientPinPosition0(getSeries(4),0.0); setGradientPinPosition1(getSeries(4),1.0); setGradientDirection(getSeries(5),3); setGradientPinLeftColor0(getSeries(5),new Color(122,121,121)); setGradientPinRightColor0(getSeries(5),new Color(122,121,121)); setGradientPinLeftColor2(getSeries(5),new Color(122,121,121)); setGradientPinRightColor2(getSeries(5),new Color(122,121,121)); setGradientPinLeftColor1(getSeries(5),new Color(122,121,121)); setGradientPinRightColor1(getSeries(5),new Color(122,121,121)); setGradientPinLeftColor0(getSeries(5), new Color(122,121,121,150)); setGradientPinRightColor0(getSeries(5), new Color(122,121,121,150)); setGradientPinLeftColor2(getSeries(5), new Color(122,121,121,150)); setGradientPinRightColor2(getSeries(5), new Color(122,121,121,150)); setGradientPinLeftColor1(getSeries(5), new Color(122,121,121,0)); setGradientPinRightColor1(getSeries(5), new Color(122,121,121,0)); setFillType(getSeries(5),4); setGradientPinLeftColor1(getSeries(5), new Color(122,121,121,210)); setGradientPinRightColor1(getSeries(5), new Color(122,121,121,210)); setGradientPinPosition0(getSeries(5),0.0); setGradientPinPosition1(getSeries(5),1.0); setGradientDirection(getSeries(6),3); setGradientPinLeftColor0(getSeries(6),new Color(96,96,173)); setGradientPinRightColor0(getSeries(6),new Color(96,96,173)); setGradientPinLeftColor2(getSeries(6),new Color(96,96,173)); setGradientPinRightColor2(getSeries(6),new Color(96,96,173)); setGradientPinLeftColor1(getSeries(6),new Color(96,96,173)); setGradientPinRightColor1(getSeries(6),new Color(96,96,173)); setGradientPinLeftColor0(getSeries(6), new Color(96,96,173,150)); setGradientPinRightColor0(getSeries(6), new Color(96,96,173,150)); setGradientPinLeftColor2(getSeries(6), new Color(96,96,173,150)); setGradientPinRightColor2(getSeries(6), new Color(96,96,173,150)); setGradientPinLeftColor1(getSeries(6), new Color(96,96,173,0)); setGradientPinRightColor1(getSeries(6), new Color(96,96,173,0)); setFillType(getSeries(6),4); setGradientPinLeftColor1(getSeries(6), new Color(96,96,173,210)); setGradientPinRightColor1(getSeries(6), new Color(96,96,173,210)); setGradientPinPosition0(getSeries(6),0.0); setGradientPinPosition1(getSeries(6),1.0); setGradientDirection(getSeries(7),3); setGradientPinLeftColor0(getSeries(7),new Color(255,164,18)); setGradientPinRightColor0(getSeries(7),new Color(255,164,18)); setGradientPinLeftColor2(getSeries(7),new Color(255,164,18)); setGradientPinRightColor2(getSeries(7),new Color(255,164,18)); setGradientPinLeftColor1(getSeries(7),new Color(255,164,18)); setGradientPinRightColor1(getSeries(7),new Color(255,164,18)); setGradientPinLeftColor0(getSeries(7), new Color(255,164,18,150)); setGradientPinRightColor0(getSeries(7), new Color(255,164,18,150)); setGradientPinLeftColor2(getSeries(7), new Color(255,164,18,150)); setGradientPinRightColor2(getSeries(7), new Color(255,164,18,150)); setGradientPinLeftColor1(getSeries(7), new Color(255,164,18,0)); setGradientPinRightColor1(getSeries(7), new Color(255,164,18,0)); setFillType(getSeries(7),4); setGradientPinLeftColor1(getSeries(7), new Color(255,164,18,210)); setGradientPinRightColor1(getSeries(7), new Color(255,164,18,210)); setGradientPinPosition0(getSeries(7),0.0); setGradientPinPosition1(getSeries(7),1.0); setGradientDirection(getSeries(8),3); setGradientPinLeftColor0(getSeries(8),new Color(51,1,52)); setGradientPinRightColor0(getSeries(8),new Color(51,1,52)); setGradientPinLeftColor2(getSeries(8),new Color(51,1,52)); setGradientPinRightColor2(getSeries(8),new Color(51,1,52)); setGradientPinLeftColor1(getSeries(8),new Color(51,1,52)); setGradientPinRightColor1(getSeries(8),new Color(51,1,52)); setGradientPinLeftColor0(getSeries(8), new Color(51,1,52,150)); setGradientPinRightColor0(getSeries(8), new Color(51,1,52,150)); setGradientPinLeftColor2(getSeries(8), new Color(51,1,52,150)); setGradientPinRightColor2(getSeries(8), new Color(51,1,52,150)); setGradientPinLeftColor1(getSeries(8), new Color(51,1,52,0)); setGradientPinRightColor1(getSeries(8), new Color(51,1,52,0)); setFillType(getSeries(8),4); setGradientPinLeftColor1(getSeries(8), new Color(51,1,52,210)); setGradientPinRightColor1(getSeries(8), new Color(51,1,52,210)); setGradientPinPosition0(getSeries(8),0.0); setGradientPinPosition1(getSeries(8),1.0); setGradientDirection(getSeries(9),3); setGradientPinLeftColor0(getSeries(9),new Color(143,214,216)); setGradientPinRightColor0(getSeries(9),new Color(143,214,216)); setGradientPinLeftColor2(getSeries(9),new Color(143,214,216)); setGradientPinRightColor2(getSeries(9),new Color(143,214,216)); setGradientPinLeftColor1(getSeries(9),new Color(143,214,216)); setGradientPinRightColor1(getSeries(9),new Color(143,214,216)); setGradientPinLeftColor0(getSeries(9), new Color(143,214,216,150)); setGradientPinRightColor0(getSeries(9), new Color(143,214,216,150)); setGradientPinLeftColor2(getSeries(9), new Color(143,214,216,150)); setGradientPinRightColor2(getSeries(9), new Color(143,214,216,150)); setGradientPinLeftColor1(getSeries(9), new Color(143,214,216,0)); setGradientPinRightColor1(getSeries(9), new Color(143,214,216,0)); setFillType(getSeries(9),4); setGradientPinLeftColor1(getSeries(9), new Color(143,214,216,210)); setGradientPinRightColor1(getSeries(9), new Color(143,214,216,210)); setGradientPinPosition0(getSeries(9),0.0); setGradientPinPosition1(getSeries(9),1.0); setGradientDirection(getSeries(10),3); setGradientPinLeftColor0(getSeries(10),new Color(229,229,229)); setGradientPinRightColor0(getSeries(10),new Color(229,229,229)); setGradientPinLeftColor2(getSeries(10),new Color(229,229,229)); setGradientPinRightColor2(getSeries(10),new Color(229,229,229)); setGradientPinLeftColor1(getSeries(10),new Color(229,229,229)); setGradientPinRightColor1(getSeries(10),new Color(229,229,229)); setGradientPinLeftColor0(getSeries(10), new Color(229,229,229,150)); setGradientPinRightColor0(getSeries(10), new Color(229,229,229,150)); setGradientPinLeftColor2(getSeries(10), new Color(229,229,229,150)); setGradientPinRightColor2(getSeries(10), new Color(229,229,229,150)); setGradientPinLeftColor1(getSeries(10), new Color(229,229,229,0)); setGradientPinRightColor1(getSeries(10), new Color(229,229,229,0)); setFillType(getSeries(10),4); setGradientPinLeftColor1(getSeries(10), new Color(229,229,229,210)); setGradientPinRightColor1(getSeries(10), new Color(229,229,229,210)); setGradientPinPosition0(getSeries(10),0.0); setGradientPinPosition1(getSeries(10),1.0); setGradientDirection(getSeries(11),3); setGradientPinLeftColor0(getSeries(11),new Color(96,96,173)); setGradientPinRightColor0(getSeries(11),new Color(96,96,173)); setGradientPinLeftColor2(getSeries(11),new Color(96,96,173)); setGradientPinRightColor2(getSeries(11),new Color(96,96,173)); setGradientPinLeftColor1(getSeries(11),new Color(96,96,173)); setGradientPinRightColor1(getSeries(11),new Color(96,96,173)); setGradientPinLeftColor0(getSeries(11), new Color(96,96,173,150)); setGradientPinRightColor0(getSeries(11), new Color(96,96,173,150)); setGradientPinLeftColor2(getSeries(11), new Color(96,96,173,150)); setGradientPinRightColor2(getSeries(11), new Color(96,96,173,150)); setGradientPinLeftColor1(getSeries(11), new Color(96,96,173,0)); setGradientPinRightColor1(getSeries(11), new Color(96,96,173,0)); setFillType(getSeries(11),4); setGradientPinLeftColor1(getSeries(11), new Color(96,96,173,210)); setGradientPinRightColor1(getSeries(11), new Color(96,96,173,210)); setGradientPinPosition0(getSeries(11),0.0); setGradientPinPosition1(getSeries(11),1.0); setGradientDirection(getSeries(12),3); setGradientPinLeftColor0(getSeries(12),new Color(255,126,29)); setGradientPinRightColor0(getSeries(12),new Color(255,126,29)); setGradientPinLeftColor2(getSeries(12),new Color(255,126,29)); setGradientPinRightColor2(getSeries(12),new Color(255,126,29)); setGradientPinLeftColor1(getSeries(12),new Color(255,126,29)); setGradientPinRightColor1(getSeries(12),new Color(255,126,29)); setGradientPinLeftColor0(getSeries(12), new Color(255,126,29,150)); setGradientPinRightColor0(getSeries(12), new Color(255,126,29,150)); setGradientPinLeftColor2(getSeries(12), new Color(255,126,29,150)); setGradientPinRightColor2(getSeries(12), new Color(255,126,29,150)); setGradientPinLeftColor1(getSeries(12), new Color(255,126,29,0)); setGradientPinRightColor1(getSeries(12), new Color(255,126,29,0)); setFillType(getSeries(12),4); setGradientPinLeftColor1(getSeries(12), new Color(255,126,29,210)); setGradientPinRightColor1(getSeries(12), new Color(255,126,29,210)); setGradientPinPosition0(getSeries(12),0.0); setGradientPinPosition1(getSeries(12),1.0); setGradientDirection(getSeries(13),3); setGradientPinLeftColor0(getSeries(13),new Color(116,26,86)); setGradientPinRightColor0(getSeries(13),new Color(116,26,86)); setGradientPinLeftColor2(getSeries(13),new Color(116,26,86)); setGradientPinRightColor2(getSeries(13),new Color(116,26,86)); setGradientPinLeftColor1(getSeries(13),new Color(116,26,86)); setGradientPinRightColor1(getSeries(13),new Color(116,26,86)); setGradientPinLeftColor0(getSeries(13), new Color(116,26,86,150)); setGradientPinRightColor0(getSeries(13), new Color(116,26,86,150)); setGradientPinLeftColor2(getSeries(13), new Color(116,26,86,150)); setGradientPinRightColor2(getSeries(13), new Color(116,26,86,150)); setGradientPinLeftColor1(getSeries(13), new Color(116,26,86,0)); setGradientPinRightColor1(getSeries(13), new Color(116,26,86,0)); setFillType(getSeries(13),4); setGradientPinLeftColor1(getSeries(13), new Color(116,26,86,210)); setGradientPinRightColor1(getSeries(13), new Color(116,26,86,210)); setGradientPinPosition0(getSeries(13),0.0); setGradientPinPosition1(getSeries(13),1.0); setGradientDirection(getSeries(14),3); setGradientPinLeftColor0(getSeries(14),new Color(98,133,241)); setGradientPinRightColor0(getSeries(14),new Color(98,133,241)); setGradientPinLeftColor2(getSeries(14),new Color(98,133,241)); setGradientPinRightColor2(getSeries(14),new Color(98,133,241)); setGradientPinLeftColor1(getSeries(14),new Color(98,133,241)); setGradientPinRightColor1(getSeries(14),new Color(98,133,241)); setGradientPinLeftColor0(getSeries(14), new Color(98,133,241,150)); setGradientPinRightColor0(getSeries(14), new Color(98,133,241,150)); setGradientPinLeftColor2(getSeries(14), new Color(98,133,241,150)); setGradientPinRightColor2(getSeries(14), new Color(98,133,241,150)); setGradientPinLeftColor1(getSeries(14), new Color(98,133,241,0)); setGradientPinRightColor1(getSeries(14), new Color(98,133,241,0)); setFillType(getSeries(14),4); setGradientPinLeftColor1(getSeries(14), new Color(98,133,241,210)); setGradientPinRightColor1(getSeries(14), new Color(98,133,241,210)); setGradientPinPosition0(getSeries(14),0.0); setGradientPinPosition1(getSeries(14),1.0);
Thanks Les, that fill change worked really well. Both chart types render that change differently still, but I found a combination that would work for both types, so thanks again for pointing me in the right direct.
And no... You definitely weren't the "ExIBIer" I was referring to You fixed most of the old stuff that was done by him last time you were out here!
Version: 8.2.03M, OS/Platform: Windows 7 & 10, Output: Excel, pdf, html
Posts: 63 | Location: Liberty Lake, WA - USA | Registered: June 23, 2016
Hello, Basically, there are few properties in chart fex code and few applied in style sheets. All properties applied on individual fex code, can i be included in style sheet? To my knowledge few are not working when added on style sheet and few are specific to charts and those changes make sense to have it in fex code. My question is can all property be added in style sheet if so then how are we going to differentiate the properties to be applied to respective charts.
I don't do a lot of custom style sheets but if you do add a property to a stylesheet is should be reflected on any report that uses that stylesheet. I'm not clear on your last question about differentiating between charts.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005
Hi Chuck, Lets say there is a common chart property which i need to apply with different values for different chart. When we are trying to apply it on style sheet how are we going to differentiate which property to apply on which chart. Lets say fill colour value is different for 2 types of chart and when we add that property in style sheet, how am i going to say oh this property is for Graph A and other property is for graph B. Because without this segregation all property will be applied on all graph which is not the correct way. How does conditional check on style sheet work. I tried with IF ELSE and it gave an error as style sheet cannot take dialog commands at IA layer.
You should be able to use a global variable in the style sheet and make sure in the reporting server profile (edasprof.prf) you set a default value for it. Then in the charts you can override the global variable value you want it to apply.
Conditional styling to to allow ranges of values to be specified on a metric field and based on the falue display the color assigned. Right mouse click on the measure and choose Other / Traffic Light Conditions to make it work, your syntax you edited in text must have had a problem.This message has been edited. Last edited by: FP Mod Chuck,
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005