Prev: Bizarre BOL tutorial instructions
Next: Percent Calc in a Tablix
From: dale on 28 Nov 2009 23:58
I'm new to SSRS. I'm using SQL Server Express with Advanced Services,
and I have a report working. The report has a Parameter defined as
"ReportDate". In the report design, I have a subheading expression
that goes like this:

="For " & Parameters!ReportDate.Value

I'm trying to invoke the report from an ASP.net MVC app like this:

<form id="frmReader" action="
http://localhost:8080/Reports_SQLEXPRESS/Pages/Report.aspx?ItemPath=%2fReports%2fDonorAccountHistory
"
method="post" target="_blank">
<input type="hidden" name="ReportDate" value="11/06/2009" />
<input type="submit" value="Run Report" />
</form>

The report runs just fine, but I never see the ReportDate value
getting passed in and shown. I'd appreciate any help, or references
to good tutorials on passing parameters inside a <form tag> (vs. in a
URL as a GET).
From: Bruce L-C [MVP] on 30 Nov 2009 15:36
This issue here is your URL. There are two websites for the URL. Reports is
the portal. That is why no parameters are being passed. If you go to books
online you will see lots of examples on the using URL Integration but here
is an example to get you going.

http://localhost/reportserver?/folder/subfolder/report&parameter1=value1&parameter2=value2Parameters names are case sensitive.--Bruce Loehle-CongerMVP SQL Server Reporting Services"dale" <deskven(a)gmail.com> wrote in messagenews:1e55d93e-c88f-4a6f-8d1a-8bfbb4a20df5(a)b36g2000prf.googlegroups.com...> I'm new to SSRS. I'm using SQL Server Express with Advanced Services,> and I have a report working. The report has a Parameter defined as> "ReportDate". In the report design, I have a subheading expression> that goes like this:>> ="For " & Parameters!ReportDate.Value>> I'm trying to invoke the report from an ASP.net MVC app like this:>> <form id="frmReader" action=">http://localhost:8080/Reports_SQLEXPRESS/Pages/Report.aspx?ItemPath=%2fReports%2fDonorAccountHistory> "> method="post" target="_blank">> <input type="hidden" name="ReportDate" value="11/06/2009" />> <input type="submit" value="Run Report" />> </form>>> The report runs just fine, but I never see the ReportDate value> getting passed in and shown. I'd appreciate any help, or references> to good tutorials on passing parameters inside a <form tag> (vs. in a> URL as a GET).
 | 
Pages: 1
Prev: Bizarre BOL tutorial instructions
Next: Percent Calc in a Tablix