simple question...creating a drilldown on red-colored data?

Focal Point

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

November 01, 2007, 04:21 PM

Jason K.

simple question...creating a drilldown on red-colored data?

I have data that I'm conditionally formatting to RED or GREEN, but when I turn it into a drilldown, it goes right back to blue and underline because it's an HREF.

Is there any way around this? I have
Salesperson, Sales$, Commission$ and I need Sales$ when clicked to go to one report, Commission$ when clicked to go to a different report.

Thanks

November 01, 2007, 04:44 PM

Sayed

Jason,

Try this http://techsupport.informationbuilders.com/sps/81551126.html

Thanks,
Sayed

WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE

November 02, 2007, 10:35 AM

PBrightwell

Jason,

Try googling "change hyperlink color". I'm on 5.3 so I can't test it for you, but I think you will find your answer.

November 02, 2007, 12:17 PM

Jason K.

I think I'll just change the background color instead.

This is a little too complicated for this one report.

November 02, 2007, 04:07 PM

Gizmo

I was able to change the hyperlink color without any issues using the following code

TABLE FILE CAR
SUM SALES
BY COUNTRY
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=COUNTRY, COLOR=RED, WHEN=COUNTRY EQ 'ENGLAND',$
TYPE=DATA, COLUMN=COUNTRY, COLOR=GREEN, WHEN=COUNTRY EQ 'W GERMANY',$
TYPE=DATA, COLUMN=COUNTRY, COLOR=YELLOW, WHEN=COUNTRY EQ 'ITALY',$
TYPE=DATA, COLUMN=COUNTRY, COLOR=PINK, WHEN=COUNTRY EQ 'FRANCE',$
TYPE=DATA, COLUMN=COUNTRY,
  FOCEXEC=SHOWCAR(COUNTRY=COUNTRY),$
ENDSTYLE
END