Home Dashboard Directory Help
Search

Report Parameters in SSRS Data Feeds for PowerPivot by David Beavonn


Status: 

Active


1
0
Sign in
to vote
Type: Suggestion
ID: 800595
Opened: 9/13/2013 6:47:38 AM
Access Restriction: Public
0
Workaround(s)
view

Description

Need a way to hide SSRS report parameters in the data feed definition (atomsvc).

Currently report parameters are shown prominently at the front of the data feed columns. However, these are redundant since most well-written RDL will include parameters in the report body (after making them esthetically pleasing or user friendly).


There should be a way to hide report parameters from showing up at the front of the data feed, since users may mistake them for report data and/or they may be duplicate and/or they may be unfriendly. Aside from just hiding them, another possibility would be to move the SSRS report parameters into another collection available to be mapped separately into PowerPivot (similar to what happens when two tables exist in a report)


More discussion may be found here:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/db97b647-3f0c-4967-9e3d-c2c6b6a09c3e/atom-feed-and-ssrs-parameters
Some of our RDL reports are triggered from SSRS API's and users never see the report submissions exposed in "Report Manager" or "SharePoint". These types of reports can have very unfriendly parameters (business keys, surrogate keys, MDX members, snippets of XML, etc). These types of reports would never need their report parameters published into a data feed. If anything, the developer would deliberately transform and show the necessary parameters in the report body itself.
Details
Sign in to post a comment.
Sign in to post a workaround.