Discussion:
SSRS conversion to ReportViewer - multiple reports with varying parameters -
(too old to reply)
George Lewycky
2015-10-26 22:52:23 UTC
Permalink
We are migrating multiple reports for a project from SSRS off the report server onto ReportViewer ( converting RDL files to RDLC files [?] ) and while researching these posting is the best example that I can find for this scenario, our concern also is varying parameters per report.
Using: Visual Studio 2010, VB, ASP.NET 3.5

referencing these page to this Q&A regarding multiple reports with different parameters, is this the only way to code for numerous report and their related parameters ?

But is there a more dynamic method for this ?

http://forums.asp.net/t/1472608.aspx
http://forums.asp.net/t/1240076.aspx?Passing+Parameters+to+a+Local+Report+rdlc+


I found these as possible alternatives and would like you input and feedback....

http://stackoverflow.com/questions/5155169/how-to-get-parameters-and-theirs-values-from-parameterspanel-in-perpetuumsoft-re

http://helpcenter.perpetuumsoft.com/KB/a273/how-to-check-parameters-values-input-the-user-the.aspx
http://www.gotreportviewer.com/
http://spacefold.com/lisa/post/Dynamically-loading-reports-in-ReportViewers.aspx

Thanks again
George Lewycky
***@nyct.com

ssrs reportviewer parameters reports conversion ssrs
George Lewycky
2015-10-27 19:31:38 UTC
Permalink
We are migrating multiple reports for a project from SSRS (off our report server) onto ReportViewer. Using: Visual Studio 2010, VB, ASP.NET 3.5
And while researching these links below the best example that I can find for this scenario, our concern also is varying parameters per report.
Referencing these page to this Q&A regarding multiple reports with different parameters, is this the only way to code for numerous report and their related parameters?
But is there a more dynamic method for this?
http://forums.asp.net/t/1472608.aspx
http://forums.asp.net/t/1240076.aspx?Passing+Parameters+to+a+Local+Report+rdlc+
http://www.windows-tech.info/4/19e74d7c1ce7ac60.php
http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2006/10/11/passing-a-parameter-to-the-reportviewer-control.aspx
http://saedshaar.com/2011/04/15/report-viewer-parameters-in-visual-studio-2010-no-code/http://www.clementbardon.com/doc/ReportRejet.txt


code shown below is from: http://forums.asp.net/t/1472608.aspx
protected void Button1_Click(object sender, EventArgs e)
{
// Reset the ReportViewer control to default value
ReportViewer1.Reset();

// Provide the datasource for the FirstReport
GalacticDataSetTableAdapters.CustomerTableAdapter cuDa = new GalacticDataSetTableAdapters.CustomerTableAdapter();
GalacticDataSet.CustomerDataTable cuDt = cuDa.GetData();
Microsoft.Reporting.WebForms.ReportDataSource rds = new ReportDataSource("GalacticDataSet_Customer", cuDt);

// Provide the datasource for the SecondReport
GalacticDataSetTableAdapters.EmployeeTableAdapter emDa = new GalacticDataSetTableAdapters.EmployeeTableAdapter();
GalacticDataSet.EmployeeDataTable emDt = emDa.GetData();
Microsoft.Reporting.WebForms.ReportDataSource emRDS = new ReportDataSource("GalacticDataSet_Employee", emDt);


ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.DataSources.Add(emRDS);

ReportViewer1.LocalReport.ReportPath = RadioButtonList1.SelectedItem.Value+".rdlc";

if (RadioButtonList1.SelectedItem.Value == "Report")
{
ReportParameter rp = new ReportParameter("CNumber", "135184");
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });
}
if (RadioButtonList1.SelectedItem.Value == "Report2")
{
ReportParameter rp = new ReportParameter("Enumber", "1383");
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });
}

ReportViewer1.DataBind();
}

I found these as possible alternatives and would like you input and feedback....
http://stackoverflow.com/questions/5155169/how-to-get-parameters-and-theirs-values-from-parameterspanel-in-perpetuumsoft-re
http://helpcenter.perpetuumsoft.com/KB/a273/how-to-check-parameters-values-input-the-user-the.aspx
http://www.gotreportviewer.com/
http://spacefold.com/lisa/post/Dynamically-loading-reports-in-ReportViewers.aspx

Thanks again
George Lewycky
***@nyct.com

Loading...