SqlServer-QA.net

Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Reporting ServicesNotification 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 2005 Reporting Services reporthttp://support.microsoft.com/kb/951194/en-US When you use ...

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 have affect on the various SSIS packages that are dependant within this base ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Reporting ServicesNotification Contents: New, All Modifications and Delete 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 ...

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 to retrieve a report if the report is large or accessed frequently. Bear in mind that ...

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 reports. So the benefit of beginners in Reporting Services I would like to refer the ...

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

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 it is possible to install/manage Reporting Services as a windows services. Further ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Reporting ServicesNotification Contents: New, All Modifications and Delete 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 ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Reporting ServicesNotification Contents: New, All Modifications and Delete 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 ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Reporting ServicesNotification Contents: New, All Modifications and Delete 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 ...