I have been struggling with this for several days now.

I plan on integrating Reports into my applications using VS2008.  I am very familiar with using Report Design for Reporting Services but I have never used ReportViewer (WebControl).  VS2008 requires you use a Typed DataSet to Bind too and this works fine until I tried to use a query with a parameter or bind it to a stored procedure with a parameter.

When I add the Report Viewer and associate the report it creates a ObjectDataSource.

When I open the RDLC file, the "Report Parameters" section is emtpy (this confuses me because in building regular reports the @Parameter shows up in this list).

Both the query and the stored procedure (trying both methods) ask for a parameter called @Investigator.

Where do I bind this parameter and why doesn't the report viewer ask for it?  When you use ServerReport, it has a box to enter the parameter.  How do I give it a list of parameters to choose from like I would for the Report Server?

These questions are using the LocalReport and not the ServerReport.  The ServerReport works fine but I would like to try it without using the Report Server.

Any Direction is GREAT!

I figured it out.

1    //To use this code create a page with a ReportViewer (rptViewer) and
2    //a ObjectDataSource (ObjectDataSource1)
3    
4    //If your using a LocalReport you will have to configure
5    //the ObjectDataSource
6    
7    //Clear any Select Parameters added from other querys
8    ObjectDataSource1.SelectParameters.Clear();
9    
10   //Set the DataSetTableAdapter and Method
11   ObjectDataSource1.SelectMethod = "GetData";
12   ObjectDataSource1.TypeName = "BioTimeDataSetTableAdapters.ProjectTableAdapter";
13   
14   //Set the Parameters if you have any
15   ObjectDataSource1.SelectParameters.Add(new Parameter("InvestigatorID", TypeCode.String, "10"));
16   
17   
18   //Now that you have set your ObjectDataSource you can
19   //configure your ReportViewer
20   
21   
22   //Set ReportViewer to use a LocalReport file
23   rptViewer.Reset();
24   rptViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
25   rptViewer.LocalReport.ReportPath = "Projects.rdlc";
26   rptViewer.LocalReport.DataSources.Add(new ReportDataSource("[ReportDataSet]", "ObjectDataSource1"));
27   
28   //Set ReportViewer to use a ServerReport
29   rptViewer.Reset();
30   Uri uri = new Uri("https://[ReportServer]/reportserver");
31   rptViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
32   rptViewer.ServerReport.ReportServerUrl = uri;
33   rptViewer.ServerReport.ReportPath = "/Projects";
34   
35   

 I hope this helps some people.  It took my a week to figure all of this out!

Roger Johnson