I cannot get WebFOCUS 7.1 to return a pdf when it includes a SUBTOTAL. If I remove the SUBTOTAL it runs fine. Otherwise, it just hangs. Any ideas???
This is the code...
TABLE FILE HOLD_LIC PRINT ROYALTY_AMOUNT AS 'Royalty Amount' BY LICENSE_NUMBER NOPRINT SUBTOTAL AS 'Total for License # - ' BY LIC_LICENSE_TITLE AS 'Title' BY LICENSE_STATUS AS 'Status'This message has been edited. Last edited by: Kerry,
March 08, 2007, 12:52 PM
Danny-SRL
Hi, I ran this with no problems. Try it.
TABLE FILE CAR PRINT SALES AS 'MySale' BY COUNTRY NOPRINT SUBTOTAL AS 'MySub # -' BY CAR AS 'Title' BY BODYTYPE AS 'Status' ON TABLE PCHOLD FORMAT PDF END
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
March 08, 2007, 01:03 PM
Darin Lee
Don't see any problem with the code you've provided - may be in the stylesheet? I duplicated against CAR as below and it runs OK.
TABLE FILE CAR PRINT SEATS AS 'Royalty Amount' BY BODYTYPE NOPRINT SUBTOTAL AS 'Total for License # - ' BY COUNTRY AS 'Title' BY CAR AS 'Status' ON TABLE SET ONLINE-FMT PDF END
You may want to note that because you use a "NOPRINT" on the line you subtotal, it is likely to wrap and put the subtotals on the line under the Total for License # - line. Depends on the width of LIC_LICENSE_TITLE and LICENSE_STATUS.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
March 08, 2007, 01:04 PM
Darin Lee
great minds think alike!!
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
March 08, 2007, 01:12 PM
Tony A
wfd,
Not sure why you would get that problem. Never seen it myself.
I know it shouldn't make any difference but try the SUBTOTAL on a seperate line -
TABLE FILE HOLD_LIC
PRINT ROYALTY_AMOUNT AS 'Royalty Amount'
BY LICENSE_NUMBER NOPRINT
BY LIC_LICENSE_TITLE AS 'Title'
BY LICENSE_STATUS AS 'Status'
ON LICENSE_NUMBER SUBTOTAL AS 'Total for License # - '
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
March 08, 2007, 02:00 PM
webfocusdev
quote:
ON TABLE SET ONLINE-FMT PDF
Thanks for the quick replies. It looks like Darin was right...it is something in the stylesheet. I stripped out all the styling and it ran.
Thanks again!
March 08, 2007, 02:42 PM
Danny-SRL
Darin, I agree with your statement!!! Rgds,
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
September 16, 2008, 03:28 AM
Ranjan
Hi,
I tried this trick to create PDF, but it is not working. I am using across field in my request too.
quote:
Originally posted by Danny-SRL: Hi, I ran this with no problems. Try it.
TABLE FILE CAR PRINT SALES AS 'MySale' BY COUNTRY NOPRINT SUBTOTAL AS 'MySub # -' BY CAR AS 'Title' BY BODYTYPE AS 'Status' ON TABLE PCHOLD FORMAT PDF END
WF 7.1.4 Excel,PDF,HTML
September 16, 2008, 03:29 AM
Ranjan
Hi,
I tried this trick to create PDF, but it is not working. I am using across field in my request too. can any one please help me out???????????
Thanks. Ranjan
quote:
Originally posted by Danny-SRL: Hi, I ran this with no problems. Try it.
TABLE FILE CAR PRINT SALES AS 'MySale' BY COUNTRY NOPRINT SUBTOTAL AS 'MySub # -' BY CAR AS 'Title' BY BODYTYPE AS 'Status' ON TABLE PCHOLD FORMAT PDF END
[/QUOTE]
WF 7.1.4 Excel,PDF,HTML
September 16, 2008, 09:28 AM
nubi
quote:
Originally posted by Ranjan: Hi,
I tried this trick to create PDF, but it is not working. I am using across field in my request too. can any one please help me out???????????
Thanks. Ranjan
quote:
Originally posted by Danny-SRL: Hi, I ran this with no problems. Try it.
TABLE FILE CAR PRINT SALES AS 'MySale' BY COUNTRY NOPRINT SUBTOTAL AS 'MySub # -' BY CAR AS 'Title' BY BODYTYPE AS 'Status' ON TABLE PCHOLD FORMAT PDF END
[/QUOTE]
what error are you getting? how does it not work? what doesn't work? (you never provided any code) on what platform doesn't it work?
you haven't given us much detail- if you explain your problem clearly and update your signature you will find you will probably get the answer from someone
Developer Studio 7.64 Win XP Output: mostly HTML, also Excel and PDF
"Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor