Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> OEM Reports: How to do a report with a parameter ?

OEM Reports: How to do a report with a parameter ?

From: André Hartmann <andrehartmann_at_hotmail.com>
Date: Tue, 13 Jul 2004 12:35:44 +0200
Message-ID: <40f3bb01$1@olaf.komtel.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US