in

SQL Server Blogs

Voices from the UK SQL Server Community

Browse by Tags

  • 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. set fmtonly on declare @design int set @design...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Sep 2 2009
  • 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-in-ssrs-are-treated-by-sql-server.aspx It would be...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Nov 22 2007
  • 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, a table, etc. This is were filters come into their...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Nov 20 2007
  • 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 pound. Most of this is handled by regional settings...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Sep 27 2007
Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems