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
hisham99
Messages: 86
Registered: October 2008
Location: united arab emirates
Member
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
shahzaib_4vip@hotmail.com
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


Regards


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
beginnerHere
Messages: 55
Registered: October 2009
Member
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: Wed Dec 07 23:59:06 CST 2016

Total time taken to generate the page: 0.09661 seconds