
You can use map elements from map gallery, spatial data from SQL server or from ESRI (Environmental Systems Research Institute Inc.) shape files. Map – A map data visualization element combines data with geospatial data to be analyzed together.Indicator – Indicator generally shows trends by using directional images like arrows, ratings, etc., much like we used to have for KPI (Key Performance Indicator).Sparkline – It’s very much like data bar but often represents multiple data points over time to represent a single series.Data Bar – A data bar is a special type of chart which we generally place inside a tablix for representing group value in the form of a bar with respect to other group values.Report Builder 3.0 is a new enhanced report authoring tool which has a familiar Office-like ribbon and some exciting new features. We are going to deep dive with Report Builder 3.0, which comes with SQL Server 2008 R2. Report Builder 1.0 first came with SQL Server 2005 and has grown up with each subsequent release. SQL Server Reporting Services has a separate tool called Report Builder (separate downloadable) created especially for business users to do ad-hoc reporting.

Though Report Designer has an intuitive interface for creating simple to complex reports, it can be a little complex for business users who want to create ad-hoc reports. SQL Server Reporting Services (SSRS) has a report development/authoring tool called Report Designer (Business Intelligence Development Studio) for creating managed reports.
