Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] pdf error with subtotal

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] pdf error with subtotal
 Login/Join
 
Member
posted
Hi,

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,
 
Posts: 19 | Registered: January 04, 2005Report This Post
Virtuoso
posted Hide Post
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

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Expert
posted Hide Post
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 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Member
posted Hide Post
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!
 
Posts: 19 | Registered: January 04, 2005Report This Post
Virtuoso
posted Hide Post
Darin,
I agree with your statement!!!
Rgds,


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Member
posted Hide Post
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
 
Posts: 8 | Registered: July 18, 2008Report This Post
Member
posted Hide Post
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
 
Posts: 8 | Registered: July 18, 2008Report This Post
Guru
posted Hide Post
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
 
Posts: 285 | Location: UK | Registered: October 26, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] pdf error with subtotal

Copyright © 1996-2020 Information Builders