Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> OEM Reports: How to do a report with a parameter ?
Hi there,
i have a question regarding Reports on OEM Server 9i under Windows 2000. I would like to create a report the contents of which depend on a particular parameter. In my case, the report is to spit out statistics on a particular user and the user name is supposed to enter the report as a parameter, so that my report works the same for all possible users.
Example: I would like to call my report via a URL like http://....../...&UserName=blabla and then I want to use the parameter inside the report, like in a SQL statement SELECT .... WHERE ... username='&UserName'... but of course it does not work in that plain way.
Thanks,
André
:)
PS: Yes, I did RTFM (OEM) but I couldnt find anything helpful... Received on Tue Jul 13 2004 - 05:35:44 CDT