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,

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

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.

great minds think alike!!

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

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!

Darin,
I agree with your statement!!!
Rgds,

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

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]

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