how to pass parameters to a reportviewer in asp.net c#

Question

User-2079787324 posted

Hi All,

This is my first Reporting Services application. I have created a report by draging the ReportViewer control and create a dataset and adding an sql statement and i got the output. 

can anyone tell me how to create a report using parameters.

some sample code is much appreciated.

Thanks in advance

Answer 1

User-987211141 posted

Have a look on this link

http://www.codeproject.com/Articles/15597/Using-the-ASP-NET-2-0-ReportViewer-in-Local-Mode

Hope this helpful

Answer 2

User-2079787324 posted

Is there any way we can use it without sqlHelper?

it throws an error

the name 'sqlhelper' does not exist in the current context

and i am using a select statement hope its ok

Answer 3

User-987211141 posted

Is there any way we can use it without sqlHelper?

it throws an error

SqlHelper is just for establish connection with database. If you are not use helper class replace connection code with your code

rest is same.

Answer 4

User-2079787324 posted

.