All things Data Related....

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data

Browse by Tags

Related Posts
  • Blog Post: Reporting Services Tip – Automating the creation of multiple charts

    I had a question regarding automating the creation of multiple charts from one dataset, instead of having all the series being plotted on the one chart. An example of where this may be applicable if you have a dataset that has CPU usage for a number of Servers, and you want to create one chart for each...
  • Blog Post: Analysis Services Report actions and SharePoint Integrated Mode Reports

    This is one of those things that you can easily get wrong from time to time, (I have ), so thought I would share it on my blog and hopefully it will save some of you from facing the same issue. When you have Reporting Services running in SharePoint integrated mode and you want to enable an action on...
  • Blog Post: Tips & Tricks: SharePoint 2010 Performance Point Services–Reporting Services report settings

    I see this occur quite often and even I keep on repeating this mistake – when it comes to setting up the Report Server URL and Report URL properties for a Reporting Services based report (in SharePoint integrated mode) in Performance Point Services Dashboard Designer. I will quite often just copy and...
  • Blog Post: Reporting Services – Combining different datasets to be displayed in a single table in SSRS

    Regardless of version of SSRS (2005 or 2008), it is not possible to combine different datasets e.g. SQL Server database dataset, SSAS cube dataset, and XML feed. Possible workaround Some ways to achieve this would be to do this in the database during the data source retrieval. Use Linked Servers/CLR...
  • Blog Post: Report Builder 3.0: Getting Aussie Maps in the Reports

    With SQL Server 2008 R2 CTP 2 being available, I have been playing around with one of the new features – Report Builder 3.0. One of the new features in this reporting services version is the ability to create Map based reports. Out of the box we will only ship with the map of USA and each of its states...
  • Blog Post: Merry Christmas and Happy New Year Reporting Services Style :)

    This year I thought I would do something different, since I had some time on my hand (rare) . I created the below greeting card using SQL Server Reporting Services and data from SQL Azure. You will see that the gauge indicating the safe speed limit of 60km/h (Australia) is a reporting services visualisation...
  • Blog Post: Incorporating Reporting Services Reports in Word and PowerPoint

    My colleague Alan Eldridge, BI Technology Specialist at Microsoft, put together a great post on incorporating Reporting Services reports in Word and PowerPoint. With his permission I am making it available to you. This post talks about incorporating the report into Office/PowerPoint as opposed to exporting...
  • Blog Post: SQL Server 2008 Developer Training Kit

    Want some FREE training on the new developer features of SQL Server 2008? Download this developer training kit from - http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=e9c68e1b-1e0e-4299-b498-6ab3ca72a6d7 . This kit contains examples, presentations, hands on labs. It works with...