Reporting Services

Prompts for Reporting Services

I got an email earlier this week from Eric Nelson telling me about a new Silverlight parameter prompting application for Reporting Services called “Prompts for Reporting Services” that he’s developed and open-sourced, and since it’s got some features that look useful for anyone building SSRS reports on SSAS I thought I’d share it here.

Some of the features Eric highlighted in his mail are:

Internal/Global Prompts:  An internal prompt is just a regular parameter.  A Global prompt is a report that’s parameters are used as a report (you can create the prompt once and reference it from multiple reports).

Tree Prompt:  This prompt uses cascading parameters for fetching its data which makes it perform really well compared to an indented hierarchy parameter.

Cascading Search Prompt:  This prompt fetches no data to begin with and only queries the cube when a search is executed.  I have found this really useful when I parameter is required that has 1,000+ members that tend to lock up the web browser when rendering and are really hard for the user to navigate.

A few screenshots:

SingleSelectTree (2)

It’s available for download here:

2 thoughts on “Prompts for Reporting Services

  1. Hi Chris
    I wonder if you’ve ever noticed this in reporting services when designing Analysis services reports

    when you Initially design your data set using the Query Designer and think you want to fine tune the MDX using the expression DON’T I found that using this approach the expression does not update the MDX initially written in the Query Desginer , I’ve just spent a little while running in circles trying to find out why my query was wrong

    ever seen / expereinced this (using 2008 R2)

    1. Chris Webb – My name is Chris Webb, and I work on the Fabric CAT team at Microsoft. I blog about Power BI, Power Query, SQL Server Analysis Services, Azure Analysis Services and Excel.
      Chris Webb says:

      No, can you provide more details of what’s happening?

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.