Ben Maxwell Posted March 18, 2021 Share Posted March 18, 2021 It is quite possible that there is no way around this, but I am now able to successfully write some FML Code which dynamically returns images. My only issue is that when this dumps into Excel, you are able to click and drag the image around, and thereby are unable to sort the data and sort the traffic lights as well. Is there any way to tweak this code to make it happen TABLE FILE IBISAMP/GGSALES SUM GGSALES.SALES01.UNITS GGSALES.SALES01.DOLLARS COMPUTE Image/A30 = IF UNITS LE 1000000 THEN images/red_dot.png ELSE images/green_dot.png; AS Traffic,Light FOR GGSALES.SALES01.CATEGORY Coffee AS Coffee LABEL R0100 OVER Food AS Food LABEL R0200 OVER Gifts AS Gifts LABEL R0300 OVER RECAP R1000(1)/P20CB=R0100+R0200+R0300; AS Total Items OVER RECAP R1000(3)=IF R1000(1) GT 5000000 THEN images/red_dot.png ELSE IF R1000(1) LT 5000000 THEN images/green_dot.png; OVER RECAP R1100(1)/P20CB=100000*(R0100+R0200+R0300); AS Crazy Test Total OVER RECAP R1100(3)=IF R1100(1) GT 5000000 THEN images/red_dot.png ELSE IF R1000(1) LT 5000000 THEN images/green_dot.png; ON TABLE SET PAGE NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT XLSX ON TABLE SET XLSXPAGESETS ON ON TABLE SET STYLE * $ TYPE=REPORT, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, $ TYPE=DATA, COLUMN=N4, IMAGE=(Image), SIZE=(0.152778 0.166667), $ TYPE=TITLE, COLOR=WHITE, BACKCOLOR=SILVER, $ ENDSTYLE END Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted March 19, 2021 Share Posted March 19, 2021 I was not able to reproduce your sorting issue. I ran your code {after having to replace all tick marks as they didnt copy and paste as tick marks into the WF text editor) and putting the images in place on my server and was able to sort A to Z and Z to A and custom sorts by the two measures and the images moved accordingly. I am using 8.2.06.27 Link to comment Share on other sites More sharing options...
Ben Maxwell Posted March 22, 2021 Author Share Posted March 22, 2021 Interesting Here is the Original Output When I Sort of Column A, the images do follow suit (and the same as true when sorting on Columns B or C) A couple of the limitations are Cant sort of the Traffic Light Column Cant filter on the Traffic Light Column Someone can click and drag the traffic lights however they wish Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted March 22, 2021 Share Posted March 22, 2021 Benjamin Now I see what you mean I think that is Excel related and nothing you can do in WebFOCUS to fix that. I changed the output format to AHTML and the sorting works perfect under that format. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now