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

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

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

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