SSRS Advance Services and passing parameters via <form>

  • Follow


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).
0
Reply dale 11/29/2009 4:58:23 AM

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@gmail.com> wrote in messagenews:1e55d93e-c88f-4a6f-8d1a-8bfbb4a20df5@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).
0
Reply Bruce 11/30/2009 8:36:34 PM


1 Replies
496 Views

(page loaded in 0.023 seconds)

Similiar Articles:
















7/30/2012 2:05:22 PM


Reply: