Just a small help with user vars

ead

Hi
I want to do some SQL like that
Select *
from X
Where X.count < Y

Where Y is a parameter the user will give me on runtime
How can I do it please?

mwilliams

Hi ead,

You need to set up a report parameter for the user to enter a value into. Then you make your query like this:

select *
from X
where X.count < ?

Then, you go to the parameters section of your edit dataSet window and tie the report parameter you created to the dataSet parameter.

Hope this helps.