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:
It’s available for download here: