Magenic Technologies Community Blog

This week I received an email from a BI Developer in New York in regards to a posting I did earlier this year, Mapping data with SSRS 2008 R2, wondering why the map was not working with their dataset.  I took a look at their screenshots and based on what I saw I quickly realized that the Map Gallery option with the new Map report item is case ...

Still exploring around in the recently release SQL Server 2008 R2 August CTP and this morning I am checking out the Report Manager interface.  Here are some before and after screenshots comparing 2008 and 2008 R2: 2008      2008 R2       Displays current location in the Browser’s title, removed the ugly tabs, new ...

So I tracked down the download for Report Builder 3.0 August CTP and went through the install to see what the big changes were.  Here are some screenshots of my installation experience:         138 MB required for install (compared to 86 MB with the Report Builder 2.0 installation - Report Builder 2.0 RTM install and overview)   ...

So I was testing out the new Map Report Item in SSRS 2008 R2 August CTP last night and this morning.  Still trying to get a feel for the new data visualization, but here are a couple of reports I put together using some data from the AdventureWorks2008 database. The first report is using the Map Gallery option and I am using the ...

After working with Reporting Services since the beta product when it was code named ‘Rosetta’ I finally got my first look at using the Microsoft reporting feature that is part of Visual Studio.  I have used the Crystal Reports option within Visual Studio in the past, so I was a familiar with the development environment.  The Microsoft local report ...

Finally, the ClickOnce version of Report Builder 2.0 is available with the CTP release of SQL Server 2008 SP1 (Community Technology Preview (CTP) for Service Pack 1 of SQL Server 2008).  The big changes that have been made now with this service pack are the following: Slipstream – You are now able to integrate the base installation with service ...

This past week I read Chris Webb’s recent posting Implementing Real Analysis Services DrillDown in a Reporting Services Report which I thought was very cool.  I had left a comment and was reading his reply yesterday when I saw a comment left by Darren Gosbell “Hi Chris, have seen http://www.reportsurfer.com? - it allows you to post reporting ...

Yesterday the blog posting came out on the Reporting Services Team Blog here stating that the Report Builder 2.0 RTM was available to download.  Some of the new features since the release of RC1 are the ability to open up reports on the server for editing and using shared data sources that are on the report server. So I went ahead and downloaded ...

Over the past few weeks I have had to work on a project to generate Reporting Services 2005 reports with data from an Analysis Services (SSAS) 2005 database.  I decided I would go ahead and blog about some of my discoveries and discuss the different options that are available along with any findings (gotchas).  I cannot cover every single option ...

I am fairly new to Reporting Services and spent some time today trying to get NULL to stop appearing in a column of a report. I tried some tricks I had seen on sites and finally resorted to writing a function in the report to blank out the field. I felt good that I finally had blanks showing and data when it seemed appropriate and now I ...