OraFAQ Forum: Reports & Discoverer » Can we create drill down report with parameter form of report

Home » Developer & Programmer » Reports & Discoverer » Can we create drill down report with parameter form of report (report 10g)

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

Can we create drill down report with parameter form of report [message #533255]

Tue, 29 November 2011 01:50

mitsmi
Messages: 19
Registered: November 2011

Junior Member

I am trying to open report in parameter form in drill down report.

Report message to a moderator

Re: Can we create drill down report with parameter form of report [message #533262 is a reply to message #533255]

Tue, 29 November 2011 02:07

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm not sure I understand the question; could you rephrase it, please?

Anyway: in client/server, drill-down reports were created using a button (calling the SRW.RUN_REPORT built-in). Nowadays (which includes your version - 10g), drill-down reports are created with hyperlinks instead of buttons.

Where does "parameter form" come into a game? What "parameters"? Drill-down means that you have a "big picture" and then want to narrow it - but, you already *know* all parameters you need to know. So ... /forum/fa/1580/0/

Report message to a moderator

Re: Can we create drill down report with parameter form of report [message #533417 is a reply to message #533262]

Tue, 29 November 2011 23:05

mitsmi
Messages: 19
Registered: November 2011

Junior Member

I want to display parameter form of second report. i.e. i want to accept userid and password for opening the drill down report
Example. Report B is calling from A. The parameter form of report B is to be displayed to accept userid and password.

Report message to a moderator

Re: Can we create drill down report with parameter form of report [message #533427 is a reply to message #533417]

Wed, 30 November 2011 00:02

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Why? Aren't the same credentials (that are valid for Report_A) valid for Report_B? By the way, what do you do with username and password as report parameters; where do you use them?

Report message to a moderator

Re: Can we create drill down report with parameter form of report [message #533454 is a reply to message #533427]

Wed, 30 November 2011 01:32

mitsmi
Messages: 19
Registered: November 2011

Junior Member

That is for security reason. can we do that?

Report message to a moderator

Re: Can we create drill down report with parameter form of report [message #533459 is a reply to message #533454]

Wed, 30 November 2011 01:57

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't know, never did that.

Anyway: if you try to run a report and do not provide credentials, Oracle won't execute it but prompt the user to enter "username/password@database" values. So, I suppose that you don't need to worry about it at all - Oracle will (should, in my opinion) do the whole job for you.

Mentioning security reasons: does it mean that some users aren't allowed to view the drill-down report? How about hiding the link from them (so that they wouldn't even see it)? It might have been done with the Format Trigger (you'd still have to have "list" of these users - perhaps stored in a table?).

Report message to a moderator