Can I change SQL Report Services select string at run time?

[Guest]

Report designer gives you lots of nice ways to build queries, add parameters,
filters, etc.

However, I need more control of the query at run time. Can my VS 2005 VB
WinForms application call an .rdl report stored on the server, and supply the
SQL query string at runtime?

 

[Cowboy \(Gregory A. Beamer\)]

Query string, no. But, you can write a rather complex stored procedure and
call it using your parameters and fulfill the same thing. There may be a way
around this, but I have not delved deep enough to find it. I would look at
the web services to see if there is a way to run ad hoc type reports.

You can make certain parameters optional (at least in 2005) and use them to
run alternative paths, which might also work to your advantage.

NOTE: You can change connection string for the database at run time.

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************