jetlounge

Browse by Tags

• MDX
• Report Builder
• Report Model
• Sharepoint
• SQL Server
• SQL Server 2008
• Visual Studio
• Web Parts

• Suppress Auto Update of MDX Parameter Datasets in Reporting Services 2008

  by David Leibowitz | June 25, 2009 | Comments: 148

  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 > DataSource1 </ DataSourceName >... Read More... : Reporting Services, Report Builder, SQL Server 2008, MDX

• FIX: An unexpected error has occurred, Web Parts Maintenance Page

  by David Leibowitz | February 27, 2009 | Comments: 148

  I received this error on a web part page that used the SQL Server Reporting Services native web parts for Report Browsing and report Viewing. Every time I attempted to "connect" the Viewer control to the Browser, I was kicked out to an error page with the following error message: An unexpected error has occurred. Web Parts Maintenance Page... Read More... : Reporting Services, Sharepoint, Web Parts

• Error When Deploying a Large RS Report Model

  by David Leibowitz | May 30, 2008 | Comments: 148

  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 the web.config file located in the directory: [SQL... Read More... : Reporting Services, Report Builder, Report Model

• FIX: Visual Studio cannot shut down because a modal dialog is open

  by David Leibowitz | April 09, 2008 | Comments: 148

  You might get this error message after some report development in BIDS (Business Intelligence Development Studio). It's actually a Visual Studio issue..something that has to do with VSS...and you may be afflicted even if you aren't using VSS. The Error Message states exactly: --------------------------- Microsoft Visual Studio -------------... Read More... : Reporting Services, Visual Studio

• SSRS: Report Server Installation Is Not Initialized

  by David Leibowitz | March 27, 2008 | Comments: 148

  I received this error message during model deployment: The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) To fix, I launched "Reporting Services Configuration Manager" On the Initialization (which did have a green check mark) page, I noticed two IDs, one had a check and the other did not. After attempting... Read More... : Reporting Services

• Adding Custom Code & Assemblies in Reporting Services

  by David Leibowitz | January 07, 2008 | Comments: 148

  A few good links I keep referring to regarding the addition of a custom code assembly in RDL for a SQL Reporting Services report (SSRS). Technet: Using Custom Assemblies in Reports MS Support: How To Use Custom Assemblies or Embedded Code in RS Brian Like's Blog: Writing Custom Code in Reporting Services Read More... : Reporting Services

• Report Model Filtering & Security

  by David Leibowitz | December 27, 2007 | Comments: 148

  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. A workaround is included for the bug that allows Content Managers to see all data.... Read More... : Reporting Services, Report Builder

• Model Item Security Not Consistent for Content Managers

  by David Leibowitz | December 27, 2007 | Comments: 148

  There seems to be a bug or miscommunication as it pertains to securing SQL Server Report Models using model item security from SQL Server Management Studio. There is a fairly sparce Tutorial regarding row-level security on MSDN. Their Tutorial 3 goes over Row Level Security on Report Models. It states "Security filters are always applied, even... Read More... : Reporting Services, Report Builder

• Red X Instead of Image in Reporting Services

  by David Leibowitz | December 26, 2007 | Comments: 148

  I've run into this annoyance a few times in SSRS. Instead of seeing your image on a deployed report, you see only a Red X. This typically occurs when your image is in a virtual directory. The workaround is to make the virtual folder available to ANONYMOUS access. Microsoft has acknowledged the bug and released a HotFix for it. Read More... : Reporting Services

• Gantt Charting with Reporting Services

  by David Leibowitz | December 21, 2007 | Comments: 148

  I've got an article over at SQL Server Central that describes how to get Gantt charts in SSRS using native controls, not third party. And it has a holiday spin. This is the abstact: Gantt charts in SSRS aren’t included in the 2005 release. You can purchase a third-party add-on, or, if you can wait, these powerful project tools might make it in the... Read More... : Reporting Services

• Reporting Services Data Source Connection Examples

  by David Leibowitz | December 20, 2007 | Comments: 148

  The following table lists examples of connections string for various data sources. Data Source Example Description SQL Server OLTP database data source="(local)";initial catalog=AdventureWorks Set data source type to SQL Server . Analysis Services database data source=localhost;initial catalog=Adventure Works DW Set data source type to SQL... Read More... : Reporting Services

• Passing Parameters to Reporting Services using an URL

  by David Leibowitz | December 18, 2007 | Comments: 148

  When launching SSRS reports by URL, it is often necessary to include parameters. To do so, simply include the parameter name, an equal sign, followed by the parameter. So param=value for a report where CustomerID is 1 would look like: http://localhost/ReportServer/Pages/ReportViewer.aspx?%2ReportFolder%2DemoReport&rs:Command=Render& CustomerID... Read More... : Reporting Services

• Common SSRS URL Commands

  by David Leibowitz | December 17, 2007 | Comments: 148

  &rc:Parameters=Collapsed • This collapses the parameter bar but sends the parameters in the URL in the browser &rc:Parameters=true • This shows the parameter bar and is the default &rc:Parameters=false • This prevents the parameters from being passed in the browser and expanded &rc:toolbar=false • This hides the toolbar &rc:format... Read More... : Reporting Services

• Get Ranking of Groups in SSRS - Top X Ranking

  by David Leibowitz | December 16, 2007 | Comments: 148

  Often you'd like to view a row number, or rank on a report in SQL Server Reporting Services. This is simple enough on a line item detail report with the RowNumber function. The reference to Nothing sets our scope. Just use: =RowNumber(Nothing) But now how about something a little more challenging. Perhaps we have a list of 1000 Customers and we... Read More... : Reporting Services

• Enforce Perspective Use in SQL Report Builder Models

  by David Leibowitz | December 15, 2007 | Comments: 148

  Typically you'll lock down access to a SQL Reporting Services Model by creating a Perspective, either for security or to limit the amount of attributes available for a report. By default, the main model will be available in Report Builder with children listed for your available Perspectives. But Report Builder is meant for ad-hoc generation by non... Read More... : Reporting Services