| Generate PDF [message #650281] |
Thu, 21 April 2016 07:47  |
 |
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  |
cookiemonster
Messages: 13960
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 #650290 is a reply to message #650288] |
Thu, 21 April 2016 13:26 |
John Watson
Messages: 8960
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 #650308 is a reply to message #650305] |
Fri, 22 April 2016 03:11 |
cookiemonster
Messages: 13960
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 #650310 is a reply to message #650309] |
Fri, 22 April 2016 03:46 |
cookiemonster
Messages: 13960
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 #650312 is a reply to message #650311] |
Fri, 22 April 2016 04:05 |
cookiemonster
Messages: 13960
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 |
|
compuscience
Messages: 97
Registered: September 2012
|
Member |
|
|
cookiemonster wrote on Fri, 22 April 2016 11:05Sigh - 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
