Browse by Tags

RC0 reporting services product samples - SQL Server 2008 and 2005

Published 30 July 8 10:1 AM | SSQA.net

Until SQL Server 2000 the sample databases or files are installed along with binaries & program files, since version 2005 this has been changed and they are available from Microsoft download site and SQL Server Reporting Services (SSRS) has no exclusion...

Filed under: sql server, community, codeplex, reporting services, samples

Reporting Services 2008 additional features, other than SQL Server Reporting Services 2005

Published 11 July 8 4:38 AM | SSQA.net

SQL Server Reporting Services has been introduced in 2000 version but not catched within the user environment until the Reporting Services 2005 has been rolled out. In this regard administering a Reporting Services installation requires that you know...

Filed under: sql server, 2008, 2000, reporting services, 2005, new features

EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.

Published 27 May 8 3:48 AM | SSQA.net

Granting permissions to relevant account is a required criteria within the SQL Server databases management, for this even Reporting Services is not exceptional. As per the configuration by default the users connect to the report server by using their...

Filed under: sql server, databases, security, permissions, sqlagent, reporting services, reportserver, reportservertempdb, rsexecrole

A call to the AuthzInitializeContextFromSid API function fails during the delivery of an e-mail subscription in SQL Server Reporting Services

Published 20 May 8 2:54 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 A call to the AuthzInitializeContextFromSid API function fails during the...

Filed under: sql server, kba, reporting services, api, email, subscription, call

SQL Server Reporting Services: Resources and information - all in one place

Published 13 May 8 3:30 AM | SSQA.net

During a conference few users asked about resources and information to go through the Reporting Services, as it is a general assumption from the end-user community that referring to Books Online aka BOL doesn't get them anywhere. I always recommend...

Filed under: sql server, performance, reporting services, resources, information, books online, business intelligence, troubleshooting

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 BI and Performance Point Server 2007 - good match

Published 13 March 8 5:10 AM | SSQA.net

Another tool within BI platform to use when you have the huge farm of Analysis Services data warehousing & mining database setup at your end. So the provision of BI within SQL Server 2005 is a complete enterprise-ready and scalable data warehouse...

Filed under: sql server, management, webcast, bi, tools, reporting services, elearning, performancepoint, business intelligence, 2007, training, office

SQL Server 2008 BI enahncements - what you want is what you get!

Published 25 February 8 2:49 PM | SSQA.net

So far the SQL Server 2008 Analysis Services new features were included until October CTP, top features that Microsoft would like to include within RTM version: New Aggregation designer - to browse and modify aggregation designs that are now shown grouped...

Filed under: sql server, performance, ssis, bi, ssrs, 2008, new, reporting services, enhancement, samples, business intelligence, integration services

Real-time replication with SQL Server reporting, strategies and resolution to the problems?

Published 30 January 8 12:23 PM | SSQA.net

Replication plays important role within the data-driven events in an Enterprise, vital to the sales-work force type of management. DBAs will always have a primary focus in providing protection for the data assets stored in SQL Server. Protection that...

Filed under: sql server, microsoft, data, integration, security, download, replication, reporting services, magazine, windows it pro

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

Interesting and useful cross-blogs

Published 17 January 8 3:26 AM | SSQA.net

Interesting and usefull cross-blogs from a fellow MVP on stored-procedures, transactional replication: Parse delimited string in a Stored procedure Exporting blank SRS report to excel does not render the headers Setting up Transactional Replication from...

Filed under: sql server, blogs, excel, reporting services, procedure, format, stored

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

Using feature of Creating Reports within SQL Server express 2008

Published 3 January 8 3:5 AM | SSQA.net

SQL Server Express team in Microsoft are asking users to register their opinion in developing a new report designer tool to include in SQL Server Express 2008! I should clarify that this feature will be included in SQL Express 2008 with Advances Services...

Filed under: sql server, users, 2008, ctp, bids, reporting services, newfeatures

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: Error message when you jump to another report that uses a shared data source in SQL Server 2005 Reporting Services: "One or more data sources is missing credentials"

Published 23 December 7 1:59 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: Error message when you jump to another report that uses a shared data...

Filed under: sql server, security, kba, reporting services, 2005, data source, credentials

FIX: Message when you click the Back button in Internet Explorer 7 to return to a SQL Server 2005 Reporting Services report that contains one or more DateTime parameters: "Report is being generated"

Published 17 November 7 3:16 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: Message when you click the Back button in Internet Explorer 7 to return...

Filed under: datetime, sql server, kba, reporting services, report, version7, internet explorer

How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server code name "Longhorn"

Published 27 October 7 5:50 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 How to install and how to configure SQL Server 2005 Reporting Services on...

Filed under: sql server, kba, reporting services, configuration, servers, windows 2008

FIX: Dates in the Datetimepicker control appear in the incorrect format when you view a report of SQL Server 2005 Reporting Services with SP2 on a server that is set to a German locale

Published 24 October 7 3:38 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: Dates in the Datetimepicker control appear in the incorrect format when...

Filed under: datetime, sql server, kba, service pack2, reporting services, language, report viewer, format, locale, german

FIX: Error message when you run a DML statement against a table in a SQL Server 2005 Integration Services package: "Msg 6549, Level 16, State 1, Procedure sp_FuzzyLookupTableMaintenanceInvoke, Line 0"

Published 23 October 7 6:17 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: Error message when you run a DML statement...

Filed under: sql server, ssis, error, kba, fuzzy, lookup, reporting services, sp_FuzzyLookupTableMaintenanceInvoke, error 6549