• English
• Nederlands

Or: How-to allow users to select their own hierarchy in a report

To allow users to select their own preference on how to group a report a Report Parameter can be used to fill the fixed grouping in the report.
See below example on how to link the grouping with parameters. Read more…?

SQL Server Reporting Services 2008 by default requires the SSL protocol

Unlike SQL2005, SQL Server Reporting Services 2008 by default requires the use of the SSL protocol (Secure Sockets Layer). Eventhough this is safer in general, in a situation where SSL is not used (yet) the access to reports using HTTP will mysteriously be restricted after a SQL-upgrade. Read more…?

Or: How to access and retrieve the correct data in Sharepoint lists using SQL

Sharepoint data can be retrieved by querying the list service through the SOAP interface. This was a bit too tedious for my taste and it is only necessary when there is no direct access to the MOSS SQL Server. In most corporate environments all servers reside in the same domain and are directly accessible. In this article I describe how to access the database using T-SQL and present the results in SQL Server Reporting Services. Read more…?

Or: What might cause my SSRS reports to crash after upgrading to MS Dynamics AX2009 and how to fix my T-SQL

Eventhough most tables and columns have not been changed in AX2009 a few changes to the database design do cause some much-used fields in reports to have either another name or to be located in another table. See below for an overview of the changes I had to make in the T-SQL of some of our reports. Read more…?

After creating yet another report I was suddenly confronted with a Document Map. This shows a kind of a list of favorites in a seperate window placed on the left side of the report. While this can be useful with large reports or dashboards it was unexpected in this case. Read more…?

SQL Server Reporting Services stores information on the reports which were executed on given server in an Execution Log.
By combining this table with the report catalog in a T-SQL query the resulting information gives a good idea on the usage of the reports. Read more…?

The preview mode in Visual Studio uses caching to quickly display the result of the report-in-progress. This has nothing to do with the caching of reports in the SQL Server Reporting Services Report Manager which is handled and configured seperately. Read more…?

Or: How to query LDAP using SQL and showing the results in an SSRS report

I have received several requests from users wanting to be able to print-out the Exchange Global Address List and use it as a phone list. As is usually the case this can be done using more than one methods so I will stick to the one that suited me the most. Read more…?