When (null) is not NULL
Here is an interesting SSRS-SSAS integration gotcha that got me recently. Suppose that you have the following MDX query. Needless to say, this query is most likely wrong to start […]
New Search
If you are not happy with the results below please do another search
329 search results for: query
Logging Report Builder Queries
As you probably know, the RS 2005 Report Builder lets business users create ad-hoc reports. Behind the scenes, the Query Translator converts the report metadata to the native queries supported […]
Reporting from XML documents in RS 2005
Recently, I’ve come across a question on the RS public newsgroup about how to use the new RS 2005 XML extension to report off relative nodes in an XML document. […]
Excel to the Rescue
Thanks for Marco Russo’s blog, I’ve learned that Microsoft has released an updated version (version 1.5) of the Excel 2002/2003 Add-in for SQL Server Analysis Services. I discussed in details […]
Into the Multi-dimensional Space
Lately, I’ve run into a few “multi-dimensional” posts in the public SSRS newsgroup. It seems like more and more people target SSAS 2005 cubes as a reporting source. It looks […]
Reporting off ADO.NET datasets using the RS 2005 XML Extension
In case you missed this little gem, RS 2005 comes with a brand new XML Extension which allows you to report off an XML data returned from an URL-addressable resource, […]
Export to Excel and Word with SoftArtisians’ OfficeWriter
Version 1.0 of Reporting Services doesn’t support exporting reports to Microsoft Word format. It does support exporting to Excel but developers have limited control over the Excel renderer. For example, […]
Don’t want to buy VS.NET to author reports? Try Cizer Report Builder
Many of you probably know that one of the Microsoft RS partners, Cizer, offers an ad-hoc reporting tool called Cizer Query (mentioned in my book). Now, Cizer has released a […]
New RS features in SQL Server 2005 Beta 2
For those of you who would like to know what new RS features have made it to SQL Server 2005 Beta 2, here is the list: Ability to load report […]
Follow Us
Prologika is a boutique consulting firm that specializes in Business Intelligence consulting and training. Our mission is to help organizations make sense of data by applying effectively BI technologies.
