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...
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...