SQL Server Reporting Service programming issue

Question

Hello everyone,

I understand how to manully connect to a SQL Server data source and input SQL statement to generate/publish a report on the web. My question is, I want end user to input some parameter values, then use such parameter values as SQL statement parameter values (e.g. using end user input time range as SQL statement parameters) -- then generating report based on such parameters dynamically. I am looking for any related samples/documents. Any recommendations?

thanks in advance, George

Answer 1

If you have parameters set up they will be requested in report manager.

Here is a tutorial

Answer 2

I believe you are looking for report parameters.

A pretty good tutorial on the subject can be found at this site.