Browse by Tags
September 09, 2009
SQL Reporting Services Report Builder 2.0 ClickOnce broke in the CU2 of Service Pack 1. So, if you are on Service Pack 1, get Cumulative Update 3. Be sure to install all of the files if you are running Reporting Services in SharePoint integrated mode.
July 09, 2009
In a SharePoint integrated SQL Server Reporting Services environment, you find you can access a model, open Report Builder, drag an drop a few items. But when you attempt to actually run the report you're told the model cannot be found. What? But you were just using it! The error looks like: An error...
June 25, 2009
With the MDX Query Designer in SSRS 2008 Report Designer and Report Builder 2.0, changing the main dataset overwrites the parameter datasets, which will kill any manual adjustments made. Bummer. The hack to fix is to add a SuppressAutoUpdate =true to the parameter dataset: < Query > < DataSourceName...
June 17, 2008
In SQL Server 2005 Reporting Services you can Increase your Model reusability and development productivity by creating Perspectives. You then limit the usage of a Model only to those Perspectives, rather than the huge monster views. In Report Model designer, (BIDS), select the top node of the model called...
May 30, 2008
You may recieve the error during the deployment of a Reporting Services model: There was an exception running the extensions specified in the config file. Maximum request length exceeded. To correct, you need to increase the file size limit currently in place in the web.config on the RS Server. Find...
December 27, 2007
Filtering data in a SQL Server Report Model is rather persnickety, and there is limited instruction available online or in BOL.You use Report Models in Report Builder to develop ad-hoc SQL Reporting Services reports. This is a followup to the bug I discovered in Model Item Security as posted here and...