Advanced reporting
and data visualization components for .NET
LIVE CHAT Welcome, guest

 





set report parameters
Display Posts for:
Invert
Praveen Ramanna 08/18/2010 05:12
set report parameters

hi

How do i set report parameters through code behind. below is the sample that i am using to set the parameters,

List<Parameter> paramList = new List<Parameter>()
{
new Parameter()
{
Name="empname", Value="User #2"
}
};

reportViewer.Parameters = paramList;
reportViewer.ApplyTemplate();
reportViewer.RenderDocument();


But the report seems to use this parameter value.
[I am using Silverlight Viewer for SSRS 2005 Version 1.5.0]

Thanks
Praveen
Praveen Ramanna 08/18/2010 05:13
set report parameters

Quote:
hi

How do i set report parameters through code behind. below is the sample that i am using to set the parameters,

List&lt;Parameter> paramList = new List&lt;Parameter>()
{
new Parameter()
{
Name="empname", Value="User #2"
}
};

reportViewer.Parameters = paramList;
reportViewer.ApplyTemplate();
reportViewer.RenderDocument();


But the report seems to not use this parameter value.
[I am using Silverlight Viewer for SSRS 2005 Version 1.5.0]

Thanks
Praveen
Irina Sabaeva 08/18/2010 06:17
set report parameters

Hello,

Try to use the next code to pass parameters:

reportViewer1.Parameters.Add(newPerpetuumSoft.ReportingServices.Viewer.Client.Parameter()
{
Name = "YourParameterName",
Value = "YourValue"
});

reportViewer1.ReportName = "YourReportName";

reportViewer1.ApplyTemplate();
reportViewer1.RenderDocument();


Best regards,
Irina Sabaeva
PepretuumSoft Support Team
Praveen Ramanna 08/18/2010 06:38
set report parameters

Thanks for the reply,

here is the code
reportViewer.Parameters.Add(new Parameter()
{
Name = "ename",
Value = "User #2"
});
reportViewer.ReportName = "/EmpReport/TestReport";
reportViewer.ApplyTemplate();
reportViewer.RenderDocument();

still i am not able to get the report based on the parameters. when i set the parameters in the Change Paremters options in the report viewer, i am able to get the results for "User #2"

Thanks
Praveen
Irina Sabaeva 08/18/2010 07:47
set report parameters

Hello,

Could you please send us your rdl-report to [email protected]? We'll try to reproduce the problem.

Best regards,
Irina Sabaeva
PerpetuumSoft Support Team
Praveen Ramanna 08/18/2010 08:19
set report parameters

Hi,

I have sent the mail with the report solution attached

Thanks
Praveen