soap - Unrecognized SSRS parameters -
i'm developing ssis 2012 package uses script task load , render ssrs 2012 report ssrs server via web service using soap. problem lies in code sets parameter values. when code below runs, following soap error message when tries execute rs.setexecutionparameters method:
microsoft.reportingservices.diagnostics.utilities.unknownreportparameterexception: attempt made set report parameter 'prmdomainid' not defined in report.
yet if open report in design mode, parameter there. , checking execinfo variable @ run-time, shows parameter there. i've tried deleting report on server , redeploying didn't work. i've tried changing parameter name include leading "@" symbol didn't work either. i've made sure parameter data type (integer) matches type of value i'm passing in. i've been googling hours , nothing seems make recognize parameters i'm passing in. (note prmdomainid parameter set visible. not sure if matters.)
what missing here?
dim rs new reportexecutionservice dim format string = "html4.0" dim mimetype string = nothing dim historyid string = nothing dim deviceinfo string = nothing dim extension string = nothing dim encoding string = nothing dim warnings() warning = nothing dim streamids() string = nothing dim results() byte dim execinfo new executioninfo dim parameters(1) parametervalue parameters(0) = new parametervalue() parameters(0).name = "prmdomainid" parameters(0).value = "15" rs .credentials = system.net.credentialcache.defaultcredentials execinfo = .loadreport(reportpath, historyid) .setexecutionparameters(parameters, "en-us") results = .render(format, deviceinfo, extension, mimetype, encoding, warnings, streamids) end return system.text.encoding.default.getstring(results)
did work? have looked , looked @ - , things see don't see reportpath set - assume because got data in execinfo... other thing see don't have executionheadervalue set...
so add code , give try...
dim execheader new executionheader() rs.executionheadervalue = execheader make sure put before execinfo = .loadreport(reportpath, historyid)
i tried convert c# code vb - may want verify syntax!
Comments
Post a Comment