Hi
I am having a problem with reporting. I want to query SQL data using dataset using a query which looks lie this.
slect thisparam,thatparam from tablex where thisparam = @thisparam
thisparam is a user prompt. When the user leaves prompt value to be empty and clicks on view report i want to display the data
select thisparam,thatparam from tablex
else use the above statement with the parameters.
Could someone help me with this. Should I user filters or expression.
Thanks
SQL NEW
Basic Reporting Problem
Corsario007
Thank you it worked. Can you tell me if there are any tutorials to start for reporting services please let me know .
Thanks
SQL new
Benne
Other forums:
http://forums.microsoft.com/MSDN/default.aspx ForumGroupID=19&SiteID=1
Enjoy - Greg
Mike Awad
You can do this in your SQL statement:
select thisparam, thatparam
from tablex
where thisparam = @thisparam or @thisparam is null
If you want to treat the empty string and null as the same, then just add another or:
where thisparam = @thisparam or @thisparam is null or @thisparam = ''