Passing Quoted string into report parameter [message #2727] |
Thu, 08 August 2002 05:54 |
Godwin
Messages: 37 Registered: January 2002
|
Member |
|
|
Hi there,
Am trying to pass a parameter in reports 6i in the following format:
select pagname from mytable
where pagname like '%CLEANER%'--This works correctly.
select pagname from mytable --This retrieves no record
where pagname like :P_1
I want to generalize the report so that the parameter will accept other inpuuts from the user.
What is the proper way of achieving this result?
please help.
|
|
|
Re: Passing Quoted string into report parameter [message #2737 is a reply to message #2727] |
Thu, 08 August 2002 14:20 |
Paul
Messages: 164 Registered: April 1999
|
Senior Member |
|
|
If you are using the Report Wizard, when you create your Query with the WHERE PAGNAME LIKE :P_1 clause, it should generate a parameter form for you, if you then run the report and type %CLEANER% in as the P_1 parameter it should give the same results as running
select pagname from mytable
where pagname like '%CLEANER%'
from the command line. Your users just need to be informed how to input the parameter properly.
|
|
|