Browse by Tags

All Tags » SQL Server Reporting Services (RSS)
02 September 2009 15:27

Handling Temp tables in reporting services

Today in my 24Hrs of PASS session I highlighted the issue of using temp tables with reporting services.

My solution is to use a design time variable, and the feature that all paths are executed when FMTONLY is set ON

The code I used is along these lines ....

...
Posted by simonsabin | with no comments
Filed under: ,
04 December 2007 22:58

Installing Visual Studio 2008 and SQL Server 2005

If you are upgrading to Visual Studio 2008 then be careful with SQL Server. You may or may not know that the Business Intelligence Development Studio (BIDS) is a visual studio shell. If you don't have Visual Studio installed when you install SQL Server...
Posted by simonsabin | 3 comment(s)
Filed under: , , ,
22 November 2007 23:32

RS How To : Multi value parameters and IN clause

Following my preview two posts about using filter and with IN in the multivalue parameters. Rob Farley has posted a bit more detail on how Reporting services cheats. http://msmvps.com/blogs/robfarley/archive/2007/11/23/how-multi-value-query-parameters...
Posted by simonsabin | 2 comment(s)
Filed under: , ,
20 November 2007 19:28

RS Howto: Use the IN operator in a filter expression

Filters are not always a good thing in reports as it generally indicates you are getting more data back from the database than you need. However I often find that I want to use virtually the same data in a report jst formatted differently, i.e. a chart...
Posted by simonsabin | 4 comment(s)
Filed under: , ,
06 November 2007 14:43

What application doesn't have UNDO in today's world

Well the first that is close to my heart is Integration Services and its really annoying. I tried to track down a connect item for this but couldn't find a specific one. So I raised one https://connect.microsoft.com/SQLServer/feedback/ViewFeedback...
Posted by simonsabin | with no comments
Filed under: , , , ,
27 September 2007 11:21

SSRS Getting pounds instead of dollars

As much as I hate to admit it Microsoft is a US company which means everything defaults to US. So dates are in mmddyyyy not ddmmyyy format, words are missing letters such as color instead of colour and the currency is dollars and not the Great British...
Posted by simonsabin | 1 comment(s)
Filed under: , ,