2. I'm looking for a way to pass parameters directly to a report (these parameters carry custom text to display in the report depending on choices made by users when requesting the report and have nothing to do with the parameter in question 1 that is needed
for the sp).
Yes, We Can do like this also.. be ensure you have added starttime and endtime parameters added in Report File . For adding parameters in report
Menu Report--> Report Parameters.
// To set the parameter values
ReportParameterInfoCollection parms = ReportViewer1.LocalReport.GetParameters();
foreach(ReportParameterInfo parm in parms)
{
SetReportParameters(parm.Name);
}
In Report File you add this in filter by Table Properties -- > Data -- > Filter options Or we can display the starttime and endtime parameters in header sections.
Participant
951 Points
295 Posts
Re: Report Parameters with ReportViewer?
May 06, 2008 01:26 AM|sasi.k|LINK
Yes, We Can do like this also.. be ensure you have added starttime and endtime parameters added in Report File . For adding parameters in report
Menu Report--> Report Parameters.
// To set the parameter values
ReportParameterInfoCollection parms = ReportViewer1.LocalReport.GetParameters();
foreach(ReportParameterInfo parm in parms)
{
SetReportParameters(parm.Name);
}
private void SetReportParameters(String parameterName)
{
try
{
if(parameterName.ToLower() == "starttime")
{
ReportParameter startTimeParameter = new ReportParameter(parameterName, txtStartDate.Text);
this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { startTimeParameter });
}
else if(parameterName.ToLower() == "endtime")
{
ReportParameter endTimeParameter = new ReportParameter(parameterName, txtEndDate.Text);
this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { endTimeParameter });
}
}
catch (Exception ex)
{
throw ex;
}
}
In Report File you add this in filter by Table Properties -- > Data -- > Filter options Or we can display the starttime and endtime parameters in header sections.
For More detailed informations go thru this links
http://www.gotreportviewer.com/
http://msdn.microsoft.com/en-us/library/aa337432.aspx
Please remember to click "Mark as Answer" on this post if it helped you.