Hi,

I have recently noticed that we can present two tables using a single FEX, however the formating for the styles are off if the two reports to present have different column structures. Is there anyway to use two different styles in the same FEX so that when displaying multiple tables the styling will be different for each table?

Hi Ben,

Yes there is, and that is by using CSS within your WF styling. Example -

Put this code in a file called jssample.css within the baseapp folder on your client server

.style1 {background:#f0efc4; border:1px solid black; border-top:1px solid black;
         border-left:1px solid black; height:20px; color:black;
         font-family:arial, verdana; font-weight:bold;}

.style2 {background:#f0efc4; border:1px solid red; border-top:1px solid red;
         border-left:1px solid red; height:20px; color:red;
         font-family:ms sans serif; font-weight:100pt;}

The put this code in a fex in an application folder on your reporting server

SET CSSURL       = '/approot/baseapp/jssample.css'
TABLE FILE CAR
SUM RCOST
    DCOST
BY COUNTRY
BY CAR
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET STYLE *
  TYPE=REPORT, CLASS=style1, $
ENDSTYLE
END
TABLE FILE CAR
SUM RCOST
    DCOST
BY COUNTRY
BY CAR
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET STYLE *
  TYPE=REPORT, CLASS=style2, $
ENDSTYLE
END

Hope this helps

T

BenC,
Are you using two complete table files as in Tony's example or a single report -- kind of like TABLE FILE &TABLE -- and just changing out which table that report using via amper variables?

If you are using one TABLE FILE, you should also be able to use dialog manager. You can code two versions of the style sheet lines that need to change and use -IF and -GOTO to, etc. Not the most graceful but it works.

You could probably also create separate files and use -INCLUDE the correct file.

Let me know if you need an example using DM.

Thanks.