Home » Developer & Programmer » Forms » query for saving the called report (Oracle ,10.1.0.2.0 , win 2003 server)
query for saving the called report [message #338963] Wed, 06 August 2008 06:06 Go to next message
sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia
Member

Hi all,
I have a form which is calling many reports, I use to pass a parameter from the form and call the report and save it, but I have to do so for every report. Now I want a code which should call the reports one by one and save in memory at single click,
can anybody help me.
Thanks..
Re: query for saving the called report [message #339626 is a reply to message #338963] Fri, 08 August 2008 00:25 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Just loop through the reports.

David
Re: query for saving the called report [message #339854 is a reply to message #339626] Sat, 09 August 2008 00:21 Go to previous messageGo to next message
sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia
Member

Hi, and thanks for the reply,
can you give the sample code please
Re: query for saving the called report [message #341211 is a reply to message #339854] Sun, 17 August 2008 21:06 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
What code have you got already?

David
Re: query for saving the called report [message #341255 is a reply to message #341211] Mon, 18 August 2008 00:28 Go to previous messageGo to next message
sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia
Member

Thanks for the reply,
Actually I don't have any code, I use to open and save each and every report manually one by one, and I need a coding that automatically saves huge number of the pdf generated reports on a memory.
Thanks.
Re: query for saving the called report [message #341447 is a reply to message #341255] Mon, 18 August 2008 21:03 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you considered calling the reports from a form?

David
Re: query for saving the called report [message #341480 is a reply to message #341447] Tue, 19 August 2008 00:43 Go to previous messageGo to next message
sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia
Member

Thanks for the reply,
I am explaining the complete situation to you,
I have 10 reports, and in every report there are parameters for the month_codes and region_codes and area_codes and branch_codes and I have 5 regions and 40 areas and 276 branches and for each month I need the reports for all branches that means 276*months,
I have a form and from that form I am passing the parameters and
calling those reports which are in pdf format, what I am doing is opening the and giving the month_code,region_code,area_code and branch_code then pressing the button my report is opening with respect to the parameter I am passing from the from then
when my report is opened I am saving the report to the folder 'd:\reports' for every branch, the problem is calling every report and saving it manually, which is taking lot of time,
and no I want to place one button and if I click that button by just giving the month_code it should take all branches one by one and generates reports for all branches and save in 'd:\reports' automatically, to make this what coding should I place in my button which takes the month_code and generates all the reports in pdf format and save in the 'd:\reports' automatically.
Thanks.
Re: query for saving the called report [message #341494 is a reply to message #341480] Tue, 19 August 2008 01:49 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
My problem is that I can't see why you are having a problem. Just take your code, put in a 'loop' around the report call, populate the month field (like you are doing currently manually) and then run the report. The 'loop' will go back around, populate the next value and run the next report.

David
Re: query for saving the called report [message #341536 is a reply to message #341494] Tue, 19 August 2008 04:21 Go to previous messageGo to next message
sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia
Member

Thank you very much for your nice cooperation,
The only problem is how to save the report on the hard-drive by code.
Thanks..
Re: query for saving the called report [message #341656 is a reply to message #341536] Tue, 19 August 2008 17:20 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
How do you do that currently? Can't this information be passed as a parameter? Have you looked at ALL the parameters associated with calling a report?

David
Re: query for saving the called report [message #341810 is a reply to message #341656] Wed, 20 August 2008 06:56 Go to previous message
sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia
Member

Thank you very much djmartin,
I got succeeded using, loop thanks for your suggestion,
I will get back to you again if any other problem comes.

Previous Topic: List Box after populate_list() behaviour
Next Topic: OLE2 packege(documentation)
Goto Forum:
  


Current Time: Sun Feb 09 07:02:47 CST 2025