OraFAQ Forum: Forms » i cant run report from form

Home » Developer & Programmer » Forms » i cant run report from form (oracel 6i ,database 9i, windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

i cant run report from form [message #421724]

Thu, 10 September 2009 02:15

hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates

Senior 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

Report message to a moderator

Re: i cant run report from form [message #421790 is a reply to message #421724]

Thu, 10 September 2009 10:29

shahzaib_4vip@hotmail.com
Messages: 410
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

Report message to a moderator

Re: i cant run report from form [message #428060 is a reply to message #421724]

Tue, 27 October 2009 00:59

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

Report message to a moderator

Previous Topic:	next fiels gets grayed out
Next Topic:	return data back to calling form from called form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:38:54 CDT 2024