Home » Developer & Programmer » Reports & Discoverer » Create dynamic 'where' which the user can input on the parameter form for my select statement
Create dynamic 'where' which the user can input on the parameter form for my select statement [message #337232] Wed, 30 July 2008 04:09 Go to next message
thomasscaria
Messages: 21
Registered: July 2007
Location: Kuwait
Junior Member
Dear Members,
Can anyone upload a working report as for a study purpose demonstrating how to

Create dynamic 'where' depending on the input of the parameter form /* the "after parameter form" trigger */ for the select statement.


Thanks in advance,
Thomas.

[3 topics MERGED by LF; the rest of quasi-duplicate messages removed]

[Updated on: Wed, 30 July 2008 05:08] by Moderator

Report message to a moderator

Re: Create dynamic 'where' which the user can input on the parameter form for my select statement [message #337247 is a reply to message #337232] Wed, 30 July 2008 05:07 Go to previous message
Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It can be done by using LEXICAL PARAMETER.

Read more about it in Report Builder's Help, and search the board (now that you know keywords); there's been an answer to such a question several days ago.

Also, please, do not multipost. I have merged 3 of your topics created in 10 minutes. I don't like the idea particularly, so - take it easy with the "Create Topic" button.
Previous Topic: Matrix Report Query Problem
Next Topic: calling a report via hyperlink (merged)
Goto Forum:
  


Current Time: Wed May 15 13:29:39 CDT 2024