Showing posts with label Reporting. Show all posts
Showing posts with label Reporting. Show all posts

Sunday, September 27, 2015

SSRS - What is new in SQL Server 2016...

SQL Server 2016 is around the corner, there are lot of improvements/new features that are being deployed as part of SQL Server 2016. One of the areas where there have been improvements made is SSRS, this reporting tool has been overshadowed by Self service BI tools such as Power BI and other reporting tools. I would like to present the blog article from Matt Landis where he discusses about SSRS in SQL Server 2016.
http://windowspbx.blogspot.com/2015/05/sql-server-2016-reporting-services-ssrs.html
Some highlights from SSRS in SQL Server 2016:

  • Now supports all major browser: Internet Explorer, Chrome, Firefox, and Safari
  • Power BI Integration
  • Report templates and themes similar to Power BI
  • Customize Report Themes using CSS
  • Improved report parameter UI
  • Now supports mobile BI and data visualization on Windows, iOS, and Android devices
Please read the complete blog article from Matt to get a good overview of the new features.

Monday, August 26, 2013

Reporting Requirements...

In today's Business Intelligence world, there is a lot of requirements for reporting. There are lot of different types of reporting which includes adhoc,operational and discovery analytics reporting. In order to handle reporting requirements effectively one needs to have a strategy of how reports will be deployed and presented. One of the options is to have a Reporting Dashboard on a SSRS reporting Portal, the other options is to have a Sharepoint based Dashboard/Portal having key reports. The other aspect apart from Presenting the reports is how does one go about gathering requirements for reports. The following points/questions could be followed:

1. Decisions to be made with the Report.
2. Report Samples.
3. What is the report generation Complexity (This can be used to gauge the amount of development effort involved).
4. Report Complexity- This follows point number 3 very closely. This could given idea of what types of data sources are involved to get data for reports.
5. The Estimated number of users for the reports.
6. Report Distribution Channel .
7. Frequency of Reports.
8. Business Logic for Reports and anticipated frequency of change for Business Logic.
9. Is there a need for BI Solution (Cube Based Reports, Discovery analytics, Adhoc, Canned/Near Real time)
10. How are Reports Generated.

The above 10 points could be used as a guide for gathering reporting requirements and the feedback for these questions can give pointers to what type of reporting is required and can be generated. The list of points given is by no means exhaustive, these are some broad pointers.

Thursday, April 5, 2012

SSRS 2012

With SQL Server 2012 being released there is lot of new features all across the board which are being studied and used. The mechanisms to pull data and use data in different ways is ever exploding. SQL Server Reporting Services 2008 and 2008 R2 were good releases where in SSRS started to being looked at as a reporting tool with good features and capability. SSRS 2012 has an increased set of features, Microsoft has listed the main highlights of the new product. Sharepoint is also getting lot of traction in lots of companies these days. In order to look at what is new in SSRS 2012, here is a link:
http://msdn.microsoft.com/en-us/library/ms170438.aspx
I am planning to start working with the evaluation version of SQL Server 2012 and keep abreast of what is being offered.
As a side note: I am including a nice article on how to land a job as a developer: This appeared in SQL Server Central as well.
http://blogs.msdn.com/b/thebeebs/archive/2012/03/30/6-189-tips-for-landing-a-developer-job.aspx?CommentPosted=true#commentmessage.

Wednesday, April 29, 2009

Report Builder 2.0

Report Builder is an adhoc reporting tool which is available of the Sql Server Reporting Services. This tool would enable an user/analyst to build reports on adhoc basis. There has been a significant improvement with the Report Builder 2.0 which is available as part of SQL Server 2008. In this version the builder is more robust, almost mimics the actual Report designer environment in visual studio. There is the new tablix control along with lots of charts and gauge controls. The gauge and chart controls have been incorporated from Dundas software. The graphics on these controls is far superior to the native charts which were available in sql server 2005. With the new gauge controls one can build professional looking score cards and dashboards. The tablix control is a combination of the regular table and the matrix control, this allows user to create row and column groupings, this allows user to produce complex reports on a adhoc basis very quickly. With this version the user can export the report to Microsoft word format. The tool can be downloaded from the following Microsoft website.

http://www.microsoft.com/downloads/details.aspx?familyid=9f783224-9871-4eea-b1d5-f3140a253db6&displaylang=en