Browse by Tags

A New Record ( How many noughts ????????? )

I have to say I thought I’d seen it all but this last week brought an event of such magnitude I may be contacting the Guinness Book of Records. OK that’s not true, but I’d like to! One of our production systems has to support a certain element of real time reporting, now OLTP applications don’t really...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Sat, Jul 16 2011
SSMS Built in Reports for Server and Database Monitoring

This is a long post which I hope will format correctly – I’ve placed a pdf version for download here http://www.grumpyolddba.co.uk/sql2008/ssmsreports_grumpyolddba.pdf I sometimes discover that the built in reports for SQL Server within SSMS are an unknown, sometimes this is because not all the...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Tue, Jun 7 2011
SQL Server Denali – Whats new for reporting?

This is a placeholder for content about what’s new in SQL Server vNext aka Denali. I will be updating this as more content is published.

Posted to Simons SQL Blog (Weblog) by simonsabin on Sun, Nov 7 2010
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
SQL 2008 R2 SSRS Dissappointment

SSRS in SQL 2008 R2 was a big dissappointment. I couldn't event though about it that Microsoft developers couldn't improve and upgrade two most important things: - managing reports and - managing access control. If one has only 5 reports this concern is absolutelly out of the question. If one...

Posted to Tomaz.tsql (Weblog) by Tomaz.tsql on Fri, Jul 16 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
Performance Point RTM is now available

I got an email from MS today saying the Performance Point RTM is now generally available. Performance point is something I am interested in but as with many new technologies I have yet to dedicate any time to picking it up. If you are interested in learning Performance Point A great place to start is...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Nov 8 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

Page 1 of 2 (16 items) 1 2 Next >