reporting services - SSRS Url Access Specify Format Breaks Report When Parameter Page is Triggered -
i using ssrs (2008r2) url access render reports in web application. need specify format of report, , able using rs:format=
option, long report doesn't have required parameters need specified.
if report requires user enter parameter, fails. if remove rs:format
option url, report's parameter page come fine , if make selections, report render.
my url access url looks this: https://www.imnottelling.com/reportserver_sql2008r2/pages/reportviewer.aspx?/appreports/cool+report&rs:command=render&rc:linktarget=main
note error message receive when attempting tells me parameter missing, varies, depending on report attempted run.
this leads me believe either (a) not supported or (b) i'm missing in url.
any appreciated.
this should 'as designed' believe 'rs:' portion of url saying 'renderstate(something)'. if report has required parameters have 3 choices:
- set default
- pass them rest uri
- remove them if want autogenerate via rest uri
generally need add parameters rest uri like:
main root
http:// (servername)/reportserver/pages/reportviewer.aspx?
directory (if have one)
%2ftest%2f
itemname:
combowithparm
renderit:
&rs:command=render
parameters:
&parm=hereiampassedinthroughanurl
all @ once:
http:// (servername)/reportserver/pages/reportviewer.aspx?%2ftest%2fcombowithparm&rs:command=render&parm=hereiam
if using web application .net technologies , asp.net believe can use report viewer object. else may forced deal using report url. know read book brian larson ssrs 2008 , had example bind html form , use select node in form object set properties of service. if doing html natively may idea well. similar this:
<form id="frmrender" action="http:// (servername)/(pathtoreport)" method="post" target="_self"> <h3>my report title</h3> render in following format:<br/> <select id="rs:format" name="rs.format" size=1> <option value="html4.0">html 4.0</option> <option value="image">tiff image</option> </select> </form>
Comments
Post a Comment