Home » Developer & Programmer » Forms » running reports thru forms dynamically (10g)
running reports thru forms dynamically [message #326713] Thu, 12 June 2008 06:35 Go to next message
pvasquez
Messages: 1
Registered: November 2007
Location: Makati
Junior Member
Hi.
Our client is migrating to 10g database and will be using 10g Forms and reports.
We are currently using Developer 6. He have a form that can dynamically call any report as long as we include the report name together w/ the parameters in the 10g database.
Our problem is, I just learned that we have to define all the reports in the form so we can invoke this using run_report_object.
Is there a way i dont have to define all the reports since its one form and we have around 500 reports?
Btw, all the reports will generate text file format reports so we dont really have to let the users view this thru html format.

Re: running reports thru forms dynamically [message #326762 is a reply to message #326713] Thu, 12 June 2008 09:16 Go to previous message
mandeepmandy
Messages: 79
Registered: May 2008
Location: USA
Member

Thats not true.
You have to only create a report object in the form and you can set properties of that object at run time.This can call n number of report.
Check SET_REPORT_OBJECT syntax for more information.

Thanks
Mandeep
Previous Topic: Format masking of Numbers
Next Topic: How to populate a form blcok through cursor
Goto Forum:
  


Current Time: Mon Feb 03 07:08:38 CST 2025