Text Report Parameters

[vijay]

Hi All,
Am a novice in here.
when i click on a report,I want a dialog box to ask for a user parameter input.
I want to display this user entered parameter in my reports header.
I dont want to use this parameter in my query or criteria.
Any help is greatly appreciated.
Thanks

 

[oihjk]

Try this see if it's what you want. Clicking "OK" without typing any text will return all records.

Eric

 

[vijay]

Hi Eric,
Thanks for the effort..but it was not of much help..coz i couldnt open it because of some format error!

 

[vijay]

Clicking "OK" without typing any text will return all records but incase the user types anything...then nothing is returned..and our field in the header does not get populated.!!

 

[oihjk]

Did you get it to work? It is an A2K version. If you did what problems are you having with it? If the user types something in it will put what they typed in the box on the report header.

Eric

 

[vijay]

Yeah..I got it to work in 2000.
If you check the sql script,u'll notice the "where" clause.I dont want any clauses/criteria's there.Your example works fine,if i dont enter anything at the prompt.But If i enter the parameter, then a blank report follows or only those rows which satisfy the criteria are returned.

 

[oihjk]

OK...Sorry
I'm not understanding fully what you're wanting then. What is the purpose of this textbox?

Are you just wanting a pop up that when the user opens the report they can type something in and whatever they type appears on the report header, but doesn't filter the report?

 

[vijay]

Exactly..thats just what i want.

 

[oihjk]

Try this...

 

[vijay]

Thanks Eric.
It finally works!!!