Home » Developer & Programmer » Reports & Discoverer » Reports parameters (oracle 10g, reports 10g, windows)
Reports parameters [message #649563] Thu, 31 March 2016 02:40 Go to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
	

rep_url	:= 'http://'||srvra||':'||srvrp||'/reports/rwservlet?server='||srvrr||'&report='||softp||:reports||'&cmdkey=vikorapp&dept='||dept||'&sectn='||sectn||'&fdate='||to_char(:fdate,'DDMMYYYY')||'&tdate='||to_char(:tdate,'DDMMYYYY')||'&ecode='||ecode||'&paramform=no';

web.show_document(rep_url,'_blank');


I am using above code in my oracle 10g reports but my problem is, as you can see the parameter values are displaying in address bar.
I don't want to show these values because it is a security laps, user can change and view other departments data.

Please advice me.
Re: Reports parameters [message #649564 is a reply to message #649563] Thu, 31 March 2016 02:51 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
I would have thought you'd be using that code in whatever is calling the report rather than the report itself.
If you're using forms, as you appear to be, why aren't you using the standard method of passing parameters to a report?
Re: Reports parameters [message #649569 is a reply to message #649564] Thu, 31 March 2016 03:49 Go to previous messageGo to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
Yes, I am using form for parameters but unable to get your point, would you please write clearly.
Re: Reports parameters [message #649578 is a reply to message #649569] Thu, 31 March 2016 05:05 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
Why aren't youo using create_parameter_list and add_parameter?
Re: Reports parameters [message #649580 is a reply to message #649578] Thu, 31 March 2016 05:24 Go to previous message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
can we use parameter list in web.show_document?
Previous Topic: View is not updated.
Next Topic: After updating uifont.ali report copy paste giving junk chars
Goto Forum:
  


Current Time: Tue Jul 14 23:55:32 CDT 2020