Home » Developer & Programmer » Forms » i cant run report from form (oracel 6i ,database 9i, windows xp)
i cant run report from form [message #421724] Thu, 10 September 2009 02:15 Go to next message
Messages: 92
Registered: October 2008
Location: united arab emirates
i create a report using (pakage RPT2XLS ) to convert this report to excel sheet ..its work fine but when i call the report from form
it gives me error (ora 06508)
actually if i call the report using (rdf) it works fine
Run_Product(REPORTS,'C:\emp.rdf', Synchronous, Runtime, Filesystem, '', Null) ;

but if you use the run time its not work
Run_Product(REPORTS,'C:\emp.rep', Synchronous, Runtime, Filesystem, '', Null) ;

i need help how to call report using (rep)because i cant let user use the rdf

Re: i cant run report from form [message #421790 is a reply to message #421724] Thu, 10 September 2009 10:29 Go to previous messageGo to next message
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Please Make sure that .rep file exist in c:\emp.rep

If its working in RDF file then its defiantly work in rep format

Used save as to save file in other folder with Emp.rep

Hope its work


Shahzaib ismail
Re: i cant run report from form [message #428060 is a reply to message #421724] Tue, 27 October 2009 00:59 Go to previous message
Messages: 55
Registered: October 2009
rightly said by shahzaib...

try saving the report again to 'rep' format

even then if, for any reason, you are not able to run it, then you can make use of the 'rdf' format report and disable its properties so that the user cannot make changes or save the report... use the add_parameter(PL_ID, 'DISABLEPRINT', TEXT_PARAMETER, 'YES') paramter and some other variations for doing that
Previous Topic: next fiels gets grayed out
Next Topic: return data back to calling form from called form
Goto Forum:

Current Time: Fri Aug 18 19:07:25 CDT 2017

Total time taken to generate the page: 0.27704 seconds