Archive for the ‘SSRS’ Category

SQL Server 2008 introduced new spatial data types including a geography type that can be used to store latitude and longitude coordinates.  The new map feature in SQL Server Reporting Services 2008 R2 works with the geography type as well as with state abbreviations, state names, or state numbers. 

The built-in map feature allows you to add a map to a report and show the states in the US or the counties within a state.  You can use the map to render one or more data points, providing a slick visualization of your data by state or county within a state. Read More.


Read Full Post »

Discover the true power of Business Intelligence at the Microsoft Business Intelligence Conference at Tech·Ed North America.

BI Conference 2010

Come and see how Microsoft can help you design, build and deploy robust Business Intelligence applications for everyone in your organization while controlling costs. It is the single best place to get the latest business strategy, product information, implementation best practices, customer insights and expert guidance relating to Microsoft Business Intelligence products.


Read Full Post »

Business Intelligence Development Studio (BIDS) is the IDE from Microsoft used for developing data analysis and Business Intelligence solutions utilizing the Microsoft SQL Server Analysis Services, Reporting Services and Integration Services.

It is based on the Microsoft Visual Studio development environment but customizes with the SQL Server services-specific extensions and project types, including tools, controls and projects for reports, ETL dataflows, OLAP cubes and data mining structures.


Read Full Post »

Recently we came across a job offering for a “SQL Server Reporting Services Consultant”. Thought of sharing the roles & responsibilities of that position with you all. Here goes the list 😉

Qualifications & Experience:

  • Three or more years experience in relational database design and development using SQL Server is required.
  • One or more years experience developing reports using SQL Server Reporting Services is required.
  • Some experience in web based development, ASP.NET, C#, and .Net Framework is preferred.
  • Seasoned in the full development life cycle including requirements gathering.
  • Degree in IT/Computer Science or commensurate education and experience.
  • Experience using Agile Software Development methodology is preferred.
  • Understanding of object-oriented analysis and design of complex systems.
  • Experience developing and supporting mission critical applications that function 24 hours a day, 7 days a week.


  • Heavy customized report development.
  • Gathers requirements from product owners and works with team members to create a design supported by the architecture of the existing systems.
  • Performs ongoing Quality Assurance studies to evaluate system efficiency and compliance.
  • Participates in the implementation and maintenance of source control and release procedures.
  • Participates in new system applications demonstrations, training classes, and application system queries sessions for all internal associates when necessary.

Read Full Post »

The following code snippet can be used to get the access history of a MS Dynamics CRM 4.0 Report.


 C.Name       'Report_GUID'
,CASE  WHEN   ((PATINDEX('%CRM_FormatDate=%', E.Parameters)- 
(PATINDEX('%CRM_FullName=%', E.Parameters) + 14 )) > 0)
THEN   SUBSTRING(E.Parameters,(PATINDEX('%CRM_FullName=%', E.Parameters)+13), 
              (PATINDEX('%CRM_FormatDate=%', E.Parameters)- 
(PATINDEX('%CRM_FullName=%', E.Parameters) + 14 )))  
       END    'UserName'
ReportServer.dbo.Catalog C with(nolock) 
LEFT OUTER JOIN ReportServer.dbo.ExecutionLog  E with(nolock) ON C.ItemID = E.ReportID 


For those who want to deep dive on this Execution Log Reporting domain, please refer:

Using the Reporting Services Execution Log with CRM 4.0

Reporting Services Log Files

Auditing Report Execution using the ReportServer Database

Reading the Report Execution Log for CRM 4.0


Read Full Post »

Even BI novices can learn what goes into creating a BI solution, from planning and designing a data mart to preparing data. An Adventure Works example illustrates the first steps a company can take to ensure that its BI solution supports the strategic decisions it needs to make.

SQL Server 2008 Components in a BI Solution

SQL Server 2008 Components in a BI Solution

Read the full article by Stacia Misner.

Read Full Post »