Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Prompts for Reporting Services

with 2 comments

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)

MultiSelect (3)

It’s available for download here:

http://code.google.com/p/prompts/

Written by Chris Webb

February 4, 2011 at 11:01 am

Posted in Reporting Services

2 Responses

Subscribe to comments with RSS.

  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)

    Neuro

    October 26, 2011 at 2:08 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,296 other followers

%d bloggers like this: