I am facing a very vague problem . I really apologise the way i am presenting the problem . In my compound report, there are 3 FEXs. I am using Cascading prompt in the same report . Whenever user selects values from the listboxes and clicks run report button . Output is displayed , but sometimes the subfoot is not aligned properly , the border lines are getting distorted , they vanish and then they reappear.
I have used lot of stylesheet commands and alignment commands like headalign , but this issue happens frequently.
But the PDF and EXCEL2K format alignment is fine.
I am facing these issues in HTML ..
Does this happen in compound reports or am i missing something ??
Thank you very much
WebFOCUS 714 Windows XP Output: HTML,PDF,Excel
July 17, 2008, 11:13 AM
Tom Flynn
Arvind,
Because you have missing/NULL data, in conjunction with SQUEEZE, the columns will shrink. Use HTMTABLE, SQUEEZE=OFF, and WRAP each column to a definitive length, if, the TITLEs don't do it for you...
1. Go to your Webfocus client http:\\servername\ibi_html\wfconsole.htm
2. Select Configuration --> Performance --> Change the setting for WF_BURST_OUTPUT to OFF
WFConsultant
WF 8105M on Win7/Tomcat
July 17, 2008, 11:37 AM
arvind
HI kamesh ,
I am not able to find the configuration and performance in my webfocus version. Anyway if i find it then i dont have the privilege to restart the server.,,
Tom ,
I tried your suggestion , the report is still distorted.
Thanks Tom Thank you very much..
WebFOCUS 714 Windows XP Output: HTML,PDF,Excel
July 17, 2008, 11:40 AM
Kamesh
Do you have privilege to see your Webfocus Client?
For this setting no need to restart the webfocus server.
WFConsultant
WF 8105M on Win7/Tomcat
July 17, 2008, 12:17 PM
arvind
nope kamesh,
i dont think so.. Any other suggestions please ??
Thank you very much
WebFOCUS 714 Windows XP Output: HTML,PDF,Excel
July 17, 2008, 12:56 PM
Kamesh
Then you should talk to your Webfocus admin and try this setting on your test server.
WFConsultant
WF 8105M on Win7/Tomcat
July 18, 2008, 06:52 AM
arvind
Yes Kamesh ,
You are right , this seems to be the WF_BURST_OUT issue, but i have one more question this was an issue in WF release 5.3.3 , i am using 7.1.4 , dont you think in this release WF should display reports in excess of 16K in HTML format smoothly without ant alignment issues??
1. Do you do everything in the GUI? or Do you code outside the GUI?
2. HTML / AHTML do not function in Compound Reports the way PDF, PPT, or EXL2K/EXCEL do. 3. Have you tried TYPE=DATA, COLUMN=N17, WRAP=2.055556, $ instead of TYPE=REPORT, COLUMN=N17, WRAP=2.055556, $ for ALL of these
4. ON TABLE PCHOLD FORMAT &WFFMT.(<HTML,HTML>,<AHTML,AHTML>,<PDF,PDF>,<Excel 2000,EXL2K>,<Excel Formula,EXL2K FORMULA>.Select type of display output.
You do NOT need these in FEX 2 or 3
5. I "JUST" tried a compound report with AHTML; Does not work on 7.6.5. Active Reports ONLY work with drilldowns, it is 1 report, in, XML 6. This is BAD code:
-SET &RPT = RPT1;
-SET &OUTPUT = IF &WFFMT CONTAINS 'HTML' THEN 'ON TABLE HOLD AS ' | &RPT | ' FORMAT ' | &WFFMT ELSE
- 'ON TABLE PCHOLD FORMAT ' | &WFFMT;
-SET &OPEN = IF &WFFMT CONTAINS 'HTML' THEN ' ' ELSE 'OPEN';
-SET &CLOSE = IF &WFFMT CONTAINS 'HTML' THEN ' ' ELSE 'CLOSE';
Then REPLACE the code above, #4, with &OUTPUT &OPEN in fex #1, &OUTPUT in Fex #2, &OUTPUT &CLOSE in Fex #3, ADD, at the top of each fex(2,3) -SET &RPT = RPT2; in Fex #2, -SET &RPT = RPT3; in Fex #3
Arvind, you really didn't say much about AHTML in your previous posts on this topic. I'm assuming you have a license.
First of all, wrapping doesn't work at all in AHTML. The output is more javascript and XML than html.
Secondly, as Tom so aptly put, you cannot do multiple AHTML reports using the compound syntax you can use with the other standard formats. You can go to the HTML Layout Painter and develop an active dashboard that combines multiple active reports. There are even more capabilities in 7.6.5.
I would definitely take AHTML out of your list of possible output formats.
Congratulations on reaching 1000 posts today. You have assisted so many of us, THANKS!!!
Arvind, I made a couple of mistakes, since I put this together rather quickly:
-SET &RPT = 'RPT1'; NEED QUOTES
&OUTPUT NEEDS TO BE PLACED IN FEX 2 AND 3 FOR RPT2 AND RPT3 TO WORK - SORRY ABOUT THAT
-SET &OUTPUT = IF &WFFMT CONTAINS 'HTML' THEN 'ON TABLE HOLD AS ' | &RPT | ' FORMAT ' | &WFFMT ELSE
- 'ON TABLE PCHOLD FORMAT ' | &WFFMT;
OR
-SET &RPT = IF &WFFMT CONTAINS 'HTML' THEN ' ' ELSE 'RPT1';
-SET &OUTPUT = IF &WFFMT CONTAINS 'HTML' THEN 'ON TABLE HOLD ' ELSE 'ON TABLE PCHOLD ';
Then, for your output:
&OUTPUT &RPT FORMAT &WFFMT &OPEN Fex 1
&OUTPUT &RPT FORMAT &WFFMT Fex 2
&OUTPUT &RPT FORMAT &WFFMT &CLOSE Fex 3
Then set &RPT to RPT2 in Fex #2, RPT3 in Fex #3
Different ways to do it, "YOU" may have come up with an alternative as well!!!!!
TomThis message has been edited. Last edited by: Tom Flynn,
You are a genius.. thank you for patiently reading my code and finding out the mistakes..
I will defy try your code and let you know..
Ginny , So Sorry , i am not using AHTML format in my compound report.. Dunno y i have written in the WFFMT statement ...
Congratulations Ginny , Hey you forgot the Hillary clinton accent when she was canvassing
WebFOCUS 714 Windows XP Output: HTML,PDF,Excel
July 19, 2008, 06:40 AM
arvind
Tom ,
You are a genius..works like a charm...hats off to you..
I learnt one thing..i have a bad habit of assuming things , i thought that even in compound report normal styling for HTML will work.. and I dint tweak the code enough for the output format the way you did..
That was great..will do more research and study more manuals..
I owe a lot to all geniuses and wizards in this forum..
You can send your invoice anytime ..
WebFOCUS 714 Windows XP Output: HTML,PDF,Excel
July 19, 2008, 12:08 PM
Tom Flynn
arvind,
I am nowhere close to a genius, too many senior moments! Experience "always" counts...
Glad it worked out, even with some syntax erros on my part:
IF &WFFMT CONTAINS 'HTML'
S/B
IF &WFFMT CONTAINS 'HTM'
Could have done without winky, though, definitely don't want to go there.
I have to get in line behind Tony, Ginny, Francis, AND, a few others before I can send my invoice...