Speaking the language of business intelligence with an Australian accent

Saturday, October 29, 2005

SSRS - Report Models as a data source in Designer

At a recent user group meeting in Sydney MS Evangelist Dave Lean reminded us that developers don't need to use the Report Builder app to create reports off report models. Just create a connection to the report model you have deployed (or generated) on the report server. In the data tab of designer you'll get a drag & drop interface which closely follows the RB experience (including the very intuitive filter functionality). So now, because we're working in Designer, we can build multiple result sets off the same model and include them on the one report just as we would with any other data source. Very cool.

Here's a post by Russel Christopher on how to create the model connection.

No comments: