Home » Developer & Programmer » Reports & Discoverer » can't pass parameter through cgicmd.dat key
can't pass parameter through cgicmd.dat key [message #420349] Fri, 28 August 2009 08:34
imuharram
Messages: 48
Registered: January 2009
Member
I have a form that sends a value to a report to be generated

report is generated through below url
web.show_document('http://localhost:8889/reports/rwservlet?report=d:\rep.jsp&destype=cache&desformat=pdf&userid=username/password@tnsname&p_wo_no='||:global.wo_no);


p_wo_no is a parameter that takes its value from the form from :global.wo_no

I created a key in cgicmd.dat to hide username and password for security as clarified below

key2:  report=d:\rep.jsp  userid=username/password@tnsname destype=cache desformat=pdf


I have a button in a form to call report using below url

web.show_document('http://localhost:8889/reports/rwservlet?cmdkey=key2&p_wo_no='||:global.wo_no);


the problem is that when report is generated an empty page is displayed

[Updated on: Fri, 28 August 2009 15:35]

Report message to a moderator

Previous Topic: How to call report parameter at runtime?
Next Topic: Can you use cursors and if so, how?
Goto Forum:
  


Current Time: Thu Mar 28 11:05:14 CDT 2024