OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Reports parameters (oracle 10g, reports 10g, windows)

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

Reports parameters [message #649563]

Thu, 31 March 2016 02:40

snsiddiqui
Messages: 172
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.

Report message to a moderator

Re: Reports parameters [message #649564 is a reply to message #649563]

Thu, 31 March 2016 02:51

cookiemonster
Messages: 13919
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?

Report message to a moderator