Passing parameters via asp .net form...

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Passing parameters via asp .net form...

Author

Topic

moodi_z
Starting Member

38 Posts

Posted - 2009-03-18 : 09:11:43

Hi,

I have this code:

xxx.aspx

<rsweb:ReportViewer runat="server" ID="ReportViewer1" Font-Names="Verdana" Font-Size="8pt"
Height="532px" ProcessingMode="Remote" Width="100%" visible="false">
<ServerReport ReportPath="/OEE_REPORTS/Equipment_Availability_Analysis"
ReportServerUrl="http://Kineret/ReportServer"/>
</rsweb:ReportViewer>

xxx.aspx.cs

protected void Submit_Click(object sender, EventArgs e)
{
if (FromDate.SelectedDate > ToDate.SelectedDate)
{
//Response.Write(@"<script language='javascript'>alert('From Date can not be greater than To Date!');</script>");
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, typeof(UpdatePanel), "somerandomstring", "alert('From Date can not be greater than To Date!');", true);
}
else
{
if (!ReportViewer1.Visible) { ReportViewer1.Visible = true; ReportViewer1.CurrentPage = 1; }

Microsoft.Reporting.WebForms.ReportParameter rprameter1 = new Microsoft.Reporting.WebForms.ReportParameter("FromDate", FromDate.SelectedDate.ToString("dd/MM/yyy"));
Microsoft.Reporting.WebForms.ReportParameter rprameter2 = new Microsoft.Reporting.WebForms.ReportParameter("ToDate", ToDate.SelectedDate.ToString("dd/MM/yyy"));
Microsoft.Reporting.WebForms.ReportParameter rprameter3 = new Microsoft.Reporting.WebForms.ReportParameter("FromTime", FromHour.Text + ":" + FromMinutes.Text);
Microsoft.Reporting.WebForms.ReportParameter rprameter4 = new Microsoft.Reporting.WebForms.ReportParameter("ToTime", ToHour.Text + ":" + ToMinutes.Text);

this.ReportViewer1.ServerReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter[] { rprameter1, rprameter2, rprameter3, rprameter4 });
//this.ReportViewer1.ServerReport.Refresh();

//The path on the server after debloying
showReport(@"/OEE_REPORTS/Equipment_Availability_Analysis");
};

}

the report is refreshing but without getting the values from my form!

where is the problem?

moodi_z
Starting Member

38 Posts

Posted - 2009-03-19 : 04:37:15

Actually I found that the problem is not with the code, because it's working in one machine and in another is not! Maybe it's somthing with IIS permessions? the values of the form are not passing via IIS!
It's somthing that I can fix in the web.config? or maybe by changing credentials for the dataset?

Please help :S

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources