Focal Point
Issue in viewing output using &WFFMT

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

April 09, 2007, 09:58 AM
Prasanna
Issue in viewing output using &WFFMT
All,
I am trying to view 3 fex files(togather), in HTML,PDF and EXCEL.
Here is my concept.
Table abc
.....
ON ON TABLE PCHOLD FORMAT &WFFMT OPEN NOBREAK
End
Table def
.....
ON ON TABLE PCHOLD FORMAT &WFFMT
End
Table ghi
.....
ON ON TABLE PCHOLD FORMAT &WFFMT CLOSE
End
When i am trying to execute it i am getting
"An HTTP 500 error has been returned when attempting to communicate with the WebFOCUS web components. The application server log contains information on why this error has occurred. Contact your WebFOCUS Administrator or Information Builders Customer Support Services for further assistance"
In one of the forum it was said that we need to uncheck the Friendly HTTP errors from IE->Advanced tab.I did it but still i get the same error.
Even i used the -SET COMPOUND=OPEN before first TABLE "abc" and -SET COMPOUNT=CLOSED before "ghi" TABLE.
But when i tried with individual FEX files they were working fine.I do 35 columns of data for each fex output, and each fex will hold around 10000 records which are grouped in to 8 category.
Is it because of size of data?Do i need to modify any settings in webserver?
Let me know if you have any solutions.


Regards
R.Prasanna
April 09, 2007, 10:11 AM
FrankDutch
I think this is too much to put into one report.

3 times 10.000 records would give you more than 500 pages in pdf and the excel file will also be to big.
An html report of that size is imo not what you want.
Reconsider the way of bringing this info to the enduser instead of trying to handle the problem you get here.

Frank




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

April 09, 2007, 10:21 AM
Prasanna
Frank,
In the report output i will be showing 8 rows for a fex file.10000 records @ DB level.Data will be grouped and made as 8 rows in the report output.
But report will have 35 columns.

Regards
R.Prasanna
April 09, 2007, 10:33 AM
Leah
Have you considered a compound report option.

I've had some issues with them using the GUI tool. Found what works is to

SET COMPOUND OPEN

fex1 - includes
ON TABLE PCHOLD FORMAT &WFFMT

fex2 the same as fex1

fex3
.
.
.
ON TABLE SET ONLINE-FMT &WFFMT
ON TABLE SET COMPOUND OPEN
END


Leah
April 09, 2007, 10:34 AM
Kamesh
Prasanna,

If you run those Tables individual, is that works?


WFConsultant

WF 8105M on Win7/Tomcat
April 09, 2007, 11:28 AM
Prasanna
Hi,
Sorry for the mistake it is not 3 fex, it is 3 tables in a single fex. So for TABLES i already tested the SET COMPOUND OPEN.It gave same error.
Kamesh, yes it works fine if i execute them separately.

One of the forum member told that we need to increase the thread size @ tomcat webserver.Is that a solution?
Regards
R.Prasanna
April 09, 2007, 11:48 AM
Kamesh
Can you run this sample code?

-SET &WFFMT='EXL2K';

TABLE FILE CAR
SUM DEALER_COST
BY CAR
ON TABLE PCHOLD FORMAT &WFFMT OPEN NOBREAK
ON TABLE SET STYLE *
TYPE=REPORT,GRID=OFF,FONT=ARIAL,SIZE=8,$
ENDSTYLE
END
-RUN

TABLE FILE CAR
SUM RETAIL_COST
BY COUNTRY
ON TABLE PCHOLD FORMAT &WFFMT
ON TABLE SET STYLE *
TYPE=REPORT,GRID=OFF,FONT=ARIAL,SIZE=8,$
ENDSTYLE
END
-RUN

TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
ON TABLE PCHOLD FORMAT &WFFMT CLOSE
ON TABLE SET STYLE *
TYPE=REPORT,GRID=OFF,FONT=ARIAL,SIZE=8,$
ENDSTYLE
END
-RUN
-EXIT

Please let me know the result,


WFConsultant

WF 8105M on Win7/Tomcat
April 10, 2007, 01:58 AM
Prasanna
Kamesh,
It works fine with the all examples.I tried the way you told, for my reports.It worked fine except for PDF. While doing it for PDF i got the following error.
0 NUMBER OF RECORDS IN TABLE= 14955 LINES= 8 (FOC3218) NOTE: REPORT WILL BE PANELED; TOTAL WIDTH IS: 63.19 INCHES.
0 NUMBER OF RECORDS IN TABLE= 8459 LINES= 8 (FOC3218) NOTE: REPORT WILL BE PANELED; TOTAL WIDTH IS: 63.19 INCHES.
0 NUMBER OF RECORDS IN TABLE= 21200 LINES= 8 (FOC3218) NOTE: REPORT WILL BE PANELED; TOTAL WIDTH IS: 63.19 INCHES.

The report shouts only if i try to show all the 3 as output format.

Regards
R.Prasanna
April 10, 2007, 11:27 AM
Kamesh
Can you update your signature?

If we know the version you are working, it will be easy to solve.

If possible, can you upload your code?

The above error you can solve by adding SQUEEZE=ON on your stylesheet.


WFConsultant

WF 8105M on Win7/Tomcat
April 11, 2007, 04:42 AM
Roland
Prasanna,

I had similar problems using COMPOUND in previous releases (5.x). I do not know what 7.x is behaving like.

Your last posting says REPORT WILL BE PANELED. When I had this message COMPUND did not work. I had to make sure that the reports fit on one page in width. You might have a problem with that because of the 35 columns!

Another problem was (sometimes) the NOBREAK option. If appropriate to the needs of your report try COMPOUND without NOBREAK. This might even help you at all with your problem.

I hope my experiences help you a bit in debugging!


Roland

Prod: WF 7.1.5
Test: WF 7.6.4
Unix Sun Solaris
HTML, PDF, EXL2K
April 11, 2007, 04:54 AM
Roland
Prasanna,

I just found another older discussion of problems with COMPOUND. Maybe this also helps you a bit. It dates back to August 2004. Maybe those things still are true....

PCHOLD FORMAT PDF OPEN NOBREAK

Regards


Roland

Prod: WF 7.1.5
Test: WF 7.6.4
Unix Sun Solaris
HTML, PDF, EXL2K