X
09Jun

SSRS(Sql Server Reporting Services) Reports

What is SSRS reports?

SSRS stands for SQL Server Reporting services a server based report generation software system from Microsoft.

SSRS is reporting platform whereby reports are stored in single centralized web server.

  • Reports deployment is so simpler.
  • SSRS  reports are  generated  by using BIDS(Business intelligence development server) included with SQL Server 2008.
  • The SQL Server 2008 version of BIDS has some nice enhancements to the user interface for designing, developing and testing reports.
  • For non-developers SQL Server 2008 has a new and enhanced version of Report Builder, which was first released with SQL Server 2005.

RDLC Reports and RDL Reports.

RDLC Reports(Report definition language ‘Client’:

RDLC reports are client contained reports that are not hosted any  where. The extra c in the name means 'Client'. Generally this is an extension of the RDL language meant for use only in Visual Studio Client Applications. It exists in Visual Studio when you add a 'reporting' item.

Advantages:

  • We can use WCF service much easier to the  dataset.
  • We have more control over the dataset and can use POCO classes filled with Entity framework objects or ADO.NET directly as well as tables themselves.
  • You can do customization with add on’s in code behind.
  • It has no licensing tags to it.

Disadvantages:

  • You need to handle parameters on your own .
  • The user cannot see the parameters in a 'Report Viewer' control unless it is in remote mode and accessing an RDL report. Thus you need to make textboxes, dropdowns, and radio buttons on your own outside the control to pass to it.
  • Anything you want to do with servicing the reports for distribution you need to build yourself.

RDL Reports(Report definition language):

Report Definition Language (RDL) is a Microsoft-standard XML schema for representing reports.

RDL reports are hosted reports generally. This means you need to implement SSRS Server. They are a built in extension of Visual Studio from SQL Server for the reporting language. When you install SSRS you should have an add on’s called 'Business Intelligence Development Studio' which is much easier to work with the reports than without it.

Advantages:

  • You can host the reports in an environment that has services running for you on them.
  • You can configure security on an item or inheriting level to handle security as a standalone concept ,
  • You can configure the service to send out emails(provided you have an SMTP server you have access to) and save files on schedules
  • You have a database generally called 'ReportServer' you can query for info on the reports once published.
  • You can access these reports still through 'ReportViewer' in a client application written in ASP.NET, WPF (with a winform control bleh!), or Winforms in .NET using 'ProcessingMode.Remote'.
  •  You can set parameters a user can see and use to gain more flexibility.
  • You can configure parts of a report to be used for connection strings as 'Data Sources' as well as a sql query, xml, or other datasets as a 'Dataset'. These parts and others can be stored and configured to cache data on a regular basis.

Disadvantages:

  • We have to deploy an .rdl file to a report server and access it using that server.
  • When an RDL file is used by the ReportViewer control, the SQL related information in the RDL file is simply ignored by the control.
  • Guage objects are not supported.

Related

Connect apps and integrate data with workflows using Azure Logic Apps

Implementing complex business process has been made easy. Logic Apps in azure provide a way to imple...

Read More >

TFS to VSTS Migrations

The next evolution of TFSWhether you’re a startup or Enterprise or you’re a team of just...

Read More >

CfMD services -Dynamics NAV

CfMD services help ISVs minimize the time and effort needed to get their software solution through t...

Read More >

Upcoming Webinar - Offshore support to North American Dynamics NAV partners

Offshore support to North American Dynamics NAV partners whose customers are moving to NAV '16Wh...

Read More >

Microsoft Azure Consultant

·         Executing technical feasibility as...

Read More >

Customer Feedback

Your feedback is important to us. Please share your experience working with Canarys & the journe...

Read More >

Threading

Multi-taskingIt is a concept of performing multiple tasks over a certain period of time by executing...

Read More >

Partnership Program

We understand that the world of technology is changing rapidly from day to day and businesses have m...

Read More >

Partnership Program

The Canarys Partner Program:Canarys is all set to expand its business reach across the Globe and is ...

Read More >

Upcoming Webinar US - Plugging for Cloud, Right or Wrong

Plugging for Cloud, Right or Wrong?Cloud computing continues to be one of the most advertising topic...

Read More >

Share

Comments

Really great post!I agree with all the aspects related to SSRS Reports and RDLC Reports.Thanks for sharing.
9/20/2017 12:31:26 PM | Reply

Post a Comment

Try DevOpSmartBoard Ultimate complete Azure DevOps End-to end reporting tool

Sign Up

  • Recent
  • Popular
  • Tag
Monthly Archive
Subscribe
Name

Text/HTML
Text/HTML
Contact Us
  • *
  • *