Re: Reports in a web browser problems
From: Surfnet <j.r.l.m.batailleVERWIJDER_DIT_at_uva.nl>
Date: Wed, 15 May 2002 21:35:42 +0200
Message-ID: <abuen3$t44$1_at_news.surfnet.nl>
Date: Wed, 15 May 2002 21:35:42 +0200
Message-ID: <abuen3$t44$1_at_news.surfnet.nl>
Hello Diane,
sorry I can't help you with your first and second problem. Maybe the third.
I think you have to take a look at the parameter properties in your report.
Open the 'List of values' property and fill it out, either with static
values or a select statement like 'select 1, 1 from dual union select 2, 2
from dual' if youre parameter value is 1 or 2. The value you give the
parameter when running the report has to available in de LOV. Basically
that's what the error message is saying...
Does this help?
Regards, Joost
-- Joost Bataille University of Amsterdam ICT centre www.ic.uva.nl remove VERWIJDER_DIT to reply "Diane Johnston" <tvor_at_accesswave.ca> wrote in message news:3CDC0820.4F398DA5_at_accesswave.ca...Received on Wed May 15 2002 - 21:35:42 CEST
> I'm having some problems running reports via the web browsers. The
> Report server is installed and running properly and if using a full URL
> including all parameters, the report will function fine. but Trying to
> use the key map in cgicmd.dat returns "Key in URL was not found in the
> key map file"... The key is in the keymap file and the file is in the
> Report60\server folder (Windows NT installation).
> Entry is:
> phonerep:report=phone_directory.rdf destype=cache desformat=pdf
> server=Rep60_servername userid=scott/tiger_at_sid
> URL is http://domain/dev60cgi/rwcgi60.exe?phonerep
>
> Also trying to run a report from a form using run_product via a form run
> in a b rowser. If the path to the report is specified, then it runs on
> the NT server, not in the client browser.
>
> Third problem is passing report parameters. I have built the url:
>
http://domain/dev60cgi/rwcgi60.exe?report=sample.rdf&destype=cache&desformat =pdf&server=Rep60_servername&userid=scott/tiger_at_sid¶m1=1¶m2=2
>
> The browser returns a Rep-0788 error, the value of the restricted LOV
> parameter param1 is not among the selectable values.
>
> But the parameter is spelled correctly as it appears in the report and
> what the heck does LOV have to do with it? There is no parameter form
> used in the report so no parameter form fields defined. Maybe i need to
> define one? If i don't use paramform=yes then it won't pop up anyway.
>
> Thanks for any insight.
>
> Diane Johnston
>
> --
> Diane Johnston aka The Voice Of Reason
> tvor_at_nospam.accesswave.ca http://members.accesswave.ca/~tvor