dkim18
asked on
SQL Server Reporting Services Query COMPLETE WHERE CLAUSE PARAMETER?
Hi,
Is it possible for me to pass the where clause to the Sql server report (dataset)?
Select * from where FromDate =@FromDate and ToDate =@ToDate AND strWhere
Is it possible for me to pass the where clause to the Sql server report (dataset)?
Select * from where FromDate =@FromDate and ToDate =@ToDate AND strWhere
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Addition to my previous comment. Both queries create a stored procedure. You can use the procedure in a dataset en the variables before the AS part of the query will turn up as paramaters in SSRS.
ASKER
Thanks everyone.
planocz's comment kicked me where to look.
eiramar,
That's exactly what I did.
Thanks again.
planocz's comment kicked me where to look.
eiramar,
That's exactly what I did.
Thanks again.
ASKER
Can you explain?