Category Archives: SSRS

Whitepaper – BI on Cloud using SQL Server on Windows Azure IaaS

In the previous blog post, we learnt the basics of cloud computing and how cloud computing and business intelligence are related to each other. In this whitepaper, I have covered the following aspects of Deploying a SQL Server Business Intelligence Solution to Cloud (Windows Azure) using IaaS (Virtual Machines) offering:

  • Why BI applications should be hosted on cloud.
  • What are the various cloud offerings,which can be used for hosting BI applications.
  • Comparison of various cloud offerings and similar features on cloud IaaS (Virtual Machines).
  • Step-by-Step procedure to host a simple SQL Server BI application on cloud.

To view and download this whitepaper, follow this link: BI on Cloud using SQL Server on IaaS.

Advertisements

SQL Server 2012 – Reporting Services (SSRS) Enhancements – Learning Resources

SQL Server 2012 – High Availability Enhancements – Learning Resources
SQL Server 2012 – Database Engine Enhancements – Learning Resources
SQL Server 2012 – Transact-SQL Enhancements – Learning Resources
SQL Server 2012 – Data Quality Services (DQS) – Learning Resources
SQL Server 2012 – Integration Services (SSIS) Enhancements – Learning Resources
SQL Server 2012 – Analysis Services (SSAS) Enhancements – Learning Resources
SQL Server 2012 – Reporting Services (SSRS) Enhancements – Learning Resources
SQL Server 2012 – Power View – A New Self Service BI Tool – Learning Resources
SQL Server 2012 – PowerPivot – Enhanced Self Service BI Tool – Learning Resources
SQL Server 2012 – SQL Server Management Studio (SSMS) Enhancements – Learning Resources
SQL Server 2012 – SQL Server Data Tools (SSDT) – A New IDE – Learning Resources
SQL Server 2012 – Other Features & Enhancements – Learning Resources


The older SSRS Version has not undergone any major changes except for a couple of changes. However, a brand new Highly Interactive and Highly Rich Self-Service Reporting Tool called Power View.

New/Enhanced Features List

Following are the few minor changes in SQL Server Reporting Services (SSRS) 2012:

  • Data Alerts in SharePoint Integrated Mode: This feature alerts the users whenever there is any change in the data in the reports, depending upon the pre-defined parameter selection. This feature works only in SharePoint Integrated Mode.
  • SQL Server Reporting Services has been implemented as a SharePoint 2010 Shared Service when installed in SharePoint Integrated Mode.
  • Exported Excel Reports are Microsoft Excel 2007/2010 compatible and have “.XLSX” extension by default.
  • Exported Word Reports are Microsoft Word 2007/2010 compatible and have “.DOCX” extension by default.

Videos

Take a look at Suggested Books for Leaning SQL Server Business Intelligence for some of the best resources available for learning SQL Server BI including SSRS.

Different Ways to Add Custom Colors to SSRS Reports

SQL Server Reporting Services (SSRS) has evolved as a strong reporting tool over last few years. One of the common needs in SSRS or any reporting tool for that matter is the ability to apply different colors of our choice to match the Theme/Color Combination/Corporate Branding. SSRS offers 12 different in-built color palettes (at the time of writing this article) for charts which is pretty large number. However, it does not always meet the needs or suite the Theme. To address this need, we need to be able to apply custom colors, basically any color represented by any valid HTML Color Code, to charts. There are various approaches to apply custom colors to charts in SSRS and we will see those approaches in this article with Pros and Cons of each of the approaches. Follow this link to read full article: Different ways to create Custom Colors for Charts in SQL Server Reporting Services.