Browse by Tags

New and Modified Knowledge Base article for SQL Server 2005 Reporting Services

Published 8 May 8 3:31 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: The hatch patterns are not consistent for all the groups between the legend and the data in a chart in a SQL Server...

Filed under: sql server, report builder, kba, object, .NET, reporting services, sap, business intelligence, character, data provider, null, parentNode

SQL Server SSIS packages metadata solution pack

Published 14 April 8 3:1 AM | SSQA.net

Do you have hundreds of SSIS packages to manage? Do they run at various times to address the ETL solutions within your environment? Let's say you have to modify the base table columns, so you need to consider what kind of impact this change would...

Filed under: sql server, ssis, solution, download, report builder, etl, metadata, packages

You encounter a problem with a subscription that uses the file share delivery extension in SQL Server 2005 Reporting Services or in SQL Server 2008 Reporting Services after you upgrade Windows Server 2003 to Windows Server 2008

Published 30 January 8 9:31 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete You encounter a problem with a subscription that uses the file share delivery...

Filed under: sql server, upgrade, report builder, kba, 2008, reporting services, windows 2003

SQL Server Reporting Services - Do you cache popular reports for better performance?

Published 7 January 8 5:30 AM | SSQA.net

Do you cache or not? By default SQL Server cache stores the data & query plan in cache to provide better performance for your queries. Similary caching is also included in SQL Server Reporting Services where this caching can shorten the time required...

Filed under: sql server, performance, security, search, update, users, report builder, BOL, best practices, reporting services, books online, caching, cache reports

SQL Server 2005 Reporting Services best resource for beginners

Published 28 December 7 6:0 AM | SSQA.net

What I like within the SQL Server Reporting Services is using RDL for own formatted reports, as this gives you the complete freedom to build your own reporting designer tool, if you are not experienced in using Visual Studio based report designer or crystal...

Filed under: sql server, msdn, report builder, best practices, sql express, reporting services, tutorial, resource

TSQL to list all the reports inlcuding data sources on the SQL Server Reporting Server?

Published 27 December 7 6:35 AM | SSQA.net

Use ReportServer Go SELECT DS . Name as DataSourceName , CT . Name AS ItemName , CT . Path FROM dbo . Catalog CT INNER JOIN dbo . DataSource DS ON CT . ItemID = DS . ItemID Where Type = 2 Order by DataSourceName , ItemName...( read more ) Read More.....

Filed under: sql server, report builder, view, reporting services, tsql, data sources

How to run Reporting Services 2000 and 2005 on the same server?

Published 8 October 7 3:45 PM | SSQA.net

When I was installing SQL Server 2005 last weekend, one of the first things I wanted to find out was whether I could run SSRS 2000 and SSRS 2005 on the same computer. Nothing was carved on the Books Online stone for SQL 2005 or 2000 versions, but I presume...

Filed under: sql server, report builder, sa, 2000, 2005, repoting services, configuration, setup, rsconfig

FIX: The status of the shared schedule appears as Paused after you click Resume when you use Report Manager in SQL Server 2005 Reporting Services SP2

Published 8 October 7 2:48 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: The status of the shared schedule appears as Paused after you click...

Filed under: sql server, sp2, report builder, kba, sa, reporting services, report manager, schedule

FIX: Error message when you display a parameterized report in a Report Viewer Web part in SQL Server 2005 Reporting Services: "Object reference not set to an instance of an object"

Published 8 October 7 6:34 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: Error message when you display a parameterized report in a Report Viewer...

Filed under: sql server, report builder, kba, report, report viewer, parameterized

FIX: In Reporting Services together with SQL Server 2005 Service Pack 2, the "Save As Report" dialog box stops responding, or the "Open Report" dialog box stops responding in Report Builder

Published 6 October 7 3:0 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: In Reporting Services together with SQL Server 2005 Service Pack 2,...

Filed under: sql server, report builder, kba, service pack2, reporting services, report viewer, dialog, save as

Dynamic formatting within the reports using TSQL?

Published 3 October 7 4:56 AM | SSQA.net

I felt this is more about SQL Storage engine related blog, but there is blend of TSQL involved in tasking the dynamic reporting within the Reporting Services. Here it goes, the task is to change/highlight the color of a row, based on its value. Therefore...

Filed under: sql server, report builder, storage, reporting services, tsql, results, iif

How do I grant permission to those users so that they can view the report?

Published 6 September 7 8:59 AM | SSQA.net

You can use the Report Manager by following these steps: Go to the folder in Report Manager where you have the report and click the Show Details button in the upper right. Click the Edit icon next to the report you want to share, and then click the Security...

Filed under: sql server, security, reporting, users, report builder

Reporting Services setup in Vista, simple resolution

Published 22 August 7 8:23 AM | SSQA.net

Recently on our Development platform we have deployed the Vista operating system to test an application against this installation. Part of the project is to deploy reports for the users using reporting services components, I was able to fix the issues...

Filed under: sql server, management, ssrs, services, report builder, iis

ReportServer & ReportServerTempdb databases - how to perform maintenance on these databases?

Published 5 July 7 11:22 AM | SSQA.net

YOu may be aware that when you deploy the Reporting Services it uses two SQL Server relational databases for internal storage. By default, the databases are named ReportServer and ReportServerTempdb. They are classed as system databases for Reporting...

Filed under: sql server, indexes, report builder, tempdb, reporting services

SQL Server replication crib sheet

Published 18 May 7 10:20 AM | SSQA.net

At first I was amused to see the title and there is lot more information which is granular that you need to know. Replication is intended to be a way of distributing data automatically from a source database to one or more recipient databases. As such...

Filed under: sql server, replication, report builder, talk, simple