StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POReporting Services - Changing a report parameter property
primarykey
Id
17924396
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-07-29T12:43:01.983
FavoriteCount
0
LastActivityDate
2016-01-14T00:08:00.563
LastEditDate
2013-07-30T12:04:55.723
LastEditorUserId
746421
OwnerUserId
746421
ParentId
0
PostTypeId
1
Score
0
ViewCount
611
LastEditorDisplayName
text
Body
I'm using a RDCE for my reports on the report server. In order for my reports to work I have to set the "UsedInQuery" parameter to true, where it is false on default. However this is not a parameter that can be set during design time. One has to manually configure the parameter after it is deployed. One why to do this is to manipluate the report server database directory by first finding the reports: <pre><code>select ItemID ,Path,Name,Description ,cast(Property as xml) as Property ,cast(Parameter as xml) as Parameter from dbo.Catalog where name like 'list of databases%' </code></pre> And then updating the report parameter with the changed parameter value <pre><code>update Catalog set Parameter=' <Parameters> <UserProfileState>0</UserProfileState> <Parameter> ... <UsedInQuery>True</UsedInQuery> ... </Parameter> </Parameters>' where ItemID='someID' </code></pre> Now this all great and all that it works, but having to manipulate the database like that everytime is just not good. Therefore I'm looking at what the web service of reporting services can do. My question is, is it possible to change the report paramater any other way than by manipulating the database directly? Preferably by the web service provided from Reporting Services. What I have found was that this method comes close to what I want: <pre><code>SetItemParameters(path, parameters) </code></pre> <a href="http://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.setitemparameters.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.setitemparameters.aspx</a> Basically the above method does what I need if I can set the UsedInQuery paramter. But when trying to change a parameter through the above line will result in nothing being changed at all. I'm not sure what I'm doing wrong here. Here is part of my code, keep in mind it is in Borland C++: <pre><code> NS_ReportService2010::ItemParameter *itemPar = new NS_ReportService2010::ItemParameter(); itemPar->Name = "language"; itemPar->QueryParameter = System::True; // itemPar->AllowBlank = true; NS_ReportService2010::ArrayOfItemParameter *itemParameters = new NS_ReportService2010::ArrayOfItemParameter(); itemParameters->set_length(1); itemParameters->operator [](0) = itemPar; ReportingService->SetItemParameters("/myreport", *itemParameters); </code></pre> Am I doing anything wrong in my update? EDIT: After the reply of Ron5504 I looked into the log file and got this: <pre><code>runningrequests!ReportServer_0-2!6b4!07/30/2013-13:57:39:: v VERBOSE: SoapAction: "http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer/SetItemParameters" library!ReportServer_0-2!6b4!07/30/2013-13:57:39:: v VERBOSE: Constructed Stream Factory 'StreamFactory:19aa4462-dc7a-4a19-a505-1d0a96ce7fc4' of type 'Microsoft.ReportingServices.Library.MemoryThenFileStreamFactory' library!ReportServer_0-2!6b4!07/30/2013-13:57:39:: i INFO: Call to GetItemTypeAction(/TestReport). library!ReportServer_0-2!6b4!07/30/2013-13:57:39:: i INFO: Call to GetItemTypeAction completed. Returns 2. library!ReportServer_0-2!6b4!07/30/2013-13:57:39:: i INFO: Call to SetReportParametersAction(/TestReport). library!ReportServer_0-2!6b4!07/30/2013-13:57:39:: v VERBOSE: Transaction begin. library!ReportServer_0-2!6b4!07/30/2013-13:57:39:: i INFO: Call to SetReportParametersAction completed. library!ReportServer_0-2!6b4!07/30/2013-13:57:39:: v VERBOSE: Transaction commit. rshost!rshost!6b4!07/30/2013-13:57:39:: v VERBOSE: HttpPipelineCallback::EndOfRequest(): continue pipeline=0x00000002781A5AF0. rshost!rshost!b5c!07/30/2013-13:57:39:: v VERBOSE: ThreadContinuePipeline: processing request on pipeline=0x00000002781A5AF0, state=2, IOError=0, node=0. rshost!rshost!828!07/30/2013-13:57:43:: v VERBOSE: HttpPipeline::DisconnectCallback: releasing pipeline=0x00000002781A5AF0. rshost!rshost!b5c!07/30/2013-13:57:43:: v VERBOSE: ThreadContinuePipeline: processing request on pipeline=0x00000002781A5AF0, state=0, IOError=2250, node=0. rshost!rshost!b5c!07/30/2013-13:57:43:: v VERBOSE: State machine disconnected pipeline=0x00000002781A5AF0, state=4 ... rshost!rshost!b5c!07/30/2013-13:57:43:: v VERBOSE: HttpPipeline::DoStateDisconnected: releasing pipeline=0x00000002781A5AF0. rshost!rshost!b5c!07/30/2013-13:57:43:: v VERBOSE: HttpPipeline::ReleaseOnce: releasing pipeline=0x00000002781A5AF0. rshost!rshost!b5c!07/30/2013-13:57:43:: v VERBOSE: Destroying pipeline=0x00000002781A5AF0, callback=0x0000000278138720 ... library!WindowsService_0!224!07/30/2013-13:57:46:: v VERBOSE: Starting database version check timer. library!WindowsService_0!224!07/30/2013-13:57:46:: v VERBOSE: Verifying DB version. library!WindowsService_0!224!07/30/2013-13:57:46:: v VERBOSE: Database version check timer executed. library!WindowsService_0!122c!07/30/2013-13:58:46:: v VERBOSE: Starting database version check timer. library!WindowsService_0!122c!07/30/2013-13:58:46:: v VERBOSE: Verifying DB version. library!WindowsService_0!122c!07/30/2013-13:58:46:: v VERBOSE: Database version check timer executed. </code></pre> Furthermore I'd like to add that I found how to do it in the designer mode. By going to the Advanced tab of the report parameter. Then you put "Refresh data when the parameter changes:" to "Always refresh". Nevertheless, my question still stands, I want to know if it is possible through the SetItemParameters method. 
Tags
<c++><web-services><reporting-services><parameters>
Title
Reporting Services - Changing a report parameter property
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USFloris Devriendt
UserOwnerUserId
1. USFloris Devriendt
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.