Home » Developer & Programmer » Reports & Discoverer » Generate PDF
Generate PDF [message #650281] Thu, 21 April 2016 07:47 Go to next message
compuscience
Messages: 97
Registered: September 2012
Member
Dear Sir,
I need to generate PDF from oracle report version 2.1
But need to save each PDF from one parameter in the report
How can i do that?
Re: Generate PDF [message #650283 is a reply to message #650281] Thu, 21 April 2016 08:05 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
compuscience wrote on Thu, 21 April 2016 13:47

I need to generate PDF from oracle report version 2.1

2.1? Really? That's prehistoric.
compuscience wrote on Thu, 21 April 2016 13:47

But need to save each PDF from one parameter in the report

I'm not sure what you mean by that.
Re: Generate PDF [message #650288 is a reply to message #650283] Thu, 21 April 2016 10:41 Go to previous messageGo to next message
compuscience
Messages: 97
Registered: September 2012
Member
I mean that
I need to generate a pdf from oracle report 2.1 or 6i
You know that the pdf should have a name, i need to generate the pdf file name depending on variable in the report


And thank you for your reply

[Updated on: Thu, 21 April 2016 10:42]

Report message to a moderator

Re: Generate PDF [message #650290 is a reply to message #650288] Thu, 21 April 2016 13:26 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I have done a huge amount of work recently on generating PDFs. The answer from Uncle Oracle is to use BI Publisher: send the data to BI Pub and it will return a PDF no problem. There are licensing implications.
Re: Generate PDF [message #650292 is a reply to message #650290] Thu, 21 April 2016 16:07 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you are calling the report from a form, then you can specify DESNAME parameter's value, i.e. set it to a desired PDF name.

Or, set DESNAME in the After Parameter Form trigger, such as
:desname := 'test_' || :par_whatever ||'.pdf';
Re: Generate PDF [message #650294 is a reply to message #650292] Thu, 21 April 2016 19:33 Go to previous messageGo to next message
compuscience
Messages: 97
Registered: September 2012
Member
Thank you very much for your help
But can i put this parameter in loop to generate file per ID
As when i print citizen ID all of of them will generate in one file with one name (ID)
Can i make loop to get file per ID with the name of ID as you show me how can i do this step
Re: Generate PDF [message #650300 is a reply to message #650294] Fri, 22 April 2016 00:09 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, you can do that in a form (loop through IDs, create DESNAME per every ID and call the report using that DESNAME). I don't think that you can do it in report's After Parameter Form trigger (or any other report procedure).
Re: Generate PDF [message #650305 is a reply to message #650300] Fri, 22 April 2016 01:18 Go to previous messageGo to next message
compuscience
Messages: 97
Registered: September 2012
Member
Thank you ser,
Can you give me the syntax
Re: Generate PDF [message #650308 is a reply to message #650305] Fri, 22 April 2016 03:11 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Syntax for what exactly?
Do you not know how to set report parameters in forms - that's documented in form builder help and countless places on the web.
Do you not know how to loop through a set of file names - that's basic PL/SQL and exact syntax would depend on where the data comes from in the first place anyway.
Re: Generate PDF [message #650309 is a reply to message #650308] Fri, 22 April 2016 03:31 Go to previous messageGo to next message
compuscience
Messages: 97
Registered: September 2012
Member
Syntax for loop with parameter to take all of ID's as parameter for each generated PDF name
Re: Generate PDF [message #650310 is a reply to message #650309] Fri, 22 April 2016 03:46 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Setting the parameter is documented as I said - so go look at the documentation.
Also as I said loops are basic PL/SQL and exact syntax would depend on where the data comes from in the first place - which is not something I would know.
So give it a try yourself and if you get stuck post what you tried here and we'll help you out.
Re: Generate PDF [message #650311 is a reply to message #650310] Fri, 22 April 2016 03:56 Go to previous messageGo to next message
compuscience
Messages: 97
Registered: September 2012
Member
I need to see syntax for the new idea
I didn't understand the idea till now
If you don't know how to help me with this code, please let someone to help me
Thanks
Re: Generate PDF [message #650312 is a reply to message #650311] Fri, 22 April 2016 04:05 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Sigh - no-one can help you with the syntax of the loop as we don't know where the data you need to loop over is coming from - is it in a table? somewhere else?
No-one needs to help you with code the code to set the parameter as there are already examples all over the web.

There's nothing difficult about this, it does just boil down to:
LOOP over set of filenames

set parameter(s)
call report

END LOOP
Re: Generate PDF [message #650313 is a reply to message #650312] Fri, 22 April 2016 04:07 Go to previous message
compuscience
Messages: 97
Registered: September 2012
Member
cookiemonster wrote on Fri, 22 April 2016 11:05
Sigh - no-one can help you with the syntax of the loop as we don't know where the data you need to loop over is coming from - is it in a table? somewhere else?
No-one needs to help you with code the code to set the parameter as there are already examples all over the web.

There's nothing difficult about this, it does just boil down to:
LOOP over set of filenames

set parameter(s)
call report

END LOOP

Thanks Sir
Previous Topic: how to adjust Field height with maximum height of field
Next Topic: printer formatting not work
Goto Forum:
  


Current Time: Thu Mar 28 06:45:29 CDT 2024