in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » Tips and Tricks » Reporting (RSS)

Browse by Tags

  • Report Builder 3.0

    Report Builder 3.0 has some minor additions that make your life a better world. On that i’ve just found is the ability to know what renderer is being used. Why is that useful? Well in all the training I do on Reporting Services I always highlight the issues with Excel exporting. The main issues are due...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Jul 23 2010

  • 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

  • Reporting Services - How to rotate text on a report

    I've been trying to do this for a long time and even looked into writing some CLR code that would take some text and produce a graphic of the text rotated. Well all my prayers have been answered by a colleague of mine. Thanks Andrew. To get text rotated in reporting services all you have to do is...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Jun 1 2007

  • Update to the taskpad custom report

    Thank you to those people that informed me that my taskpad report was incorrectly reporting the backups times against the wrong type of backup. I have now fixed the report and have also included the backup types that are supported by SQL 2005. You can downlaod the new version of the taskpad custom report...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Mar 28 2007

  • Custom reports in SQL 2005 SP2

    You may have come across the fact that in SP2 you can deploy custom reports that are accessible in management studio. This reports can be run from any context in the object explorer tree. Whilst I think this is really interesting, I haven't played with it much, but Anthony has read his blog post...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Nov 16 2006
Page 1 of 1 (7 items)
Powered by Community Server (Commercial Edition), by Telligent Systems