You are currently browsing the category archive for the ‘SSRS’ category.

Lets say you have a report created using Report Builder 2.0, in my case and want to open the report in Business Intelligence Development Studio (BIDS) using Report Designer.

 There are umpteen number of places where they talk about the fact that you can open a report created in Report Builder using Report Designer, but exactly how to go about doing that is not provided.

 So, I had to go hunt for myself and am providing the steps to be able to do that.

  1. Go to the report using Report Manager, found at http://ReportServerURL/Reports
  2. Click the Properties tab across the top
  3. Click the Edit button under the Report Definition section
  4. Now you can save the report definition as a .rdl file
  5. Open the saved file in BIDS Project using Add Item functionality

Created a report in SSRS (SQL Server Reporting Services) with the SSAS (SQL Server Avalysis Services) cube as the data source. In order to make the report dynamic, since the date hierarchy (defined as day, month, quarter) and the week hierarchy (defined as day, week) don’t align (weeks can span months, quarters, etc), I defined a parameter in the report, type text (SSAS can only pass string data to the reports as parameter values), named @ParameterValue.

The behavior is dynamic as based on the passed parameter, the underlying query changes the hierarchy

This report was then linked to the cells in the cube with the Reporting Action defined in the Actions Form Editor in the cube definition in SSAS, as

Target Type: Cells
Target Object: All Cells
Condition: [Ticket Report Date].[Date Hierarchy].CURRENTMEMBER.Level.ORDINAL > 1
Report Server Name:
<ReportServer URL>
Report Path: ReportServer?/CubeReports/TicketsOpenedDetails
Parameters: UrlEscapeFragment(MEMBERTOSTR( [Ticket Report Date].[Date Hierarchy].CURRENTMEMBER ))

For week report data, the following were changed:

Condition: [Ticket Report Date].[Week Hierarchy].CURRENTMEMBER.Level.ORDINAL = 2 
Parameters: UrlEscapeFragment(MEMBERTOSTR( [Ticket Report Date].[Week Hierarchy].CURRENTMEMBER ))


July 2018
« Mar    

Blog Stats

  • 44,396 hits