Apr 27, 2015

SSRS Interview Questions & Answers (Part-2)

Q: What are the drawbacks of reporting in SSRS?
For many years, Microsoft had no direct solution for reporting with the SQL Server besides Crystal Reports. Now, they have SQL Server Reporting Services, but it does have several drawbacks. It is still complex to understand the complete functionality and structure of this new component, and many users are still relying on the reporting application they are more familiar with, which is Crystal Reports. Also, components in SSRS like Report Builder and Report Designer are meant for different users for different aspects of the report process, yet complete understanding and exposure to both is important to utilize both functions fully and extensively. There are also issues when exporting very large reports to Microsoft Excel, as it can lead to a loss of data.

Q: What are the three different part of RDL file explain them?
In visual studio RDL files has three parts.
  • Data: It contains the dataset on which we write the query. Data set is connected with data source.
  • Design: In design you can design report. Can create tables and matrix reports. Drag columns values from source.
  • Preview: to check the preview after the report run.

Q: Which language rdl files made of?
RDL files are written in XML.

Q: Can you edit the .rdl code associated with a linked report?
No, because a linked report has no .rdl code of its own. It refers to the .rdl code of the base report

Q: What is report rendering ?
Exporting a report data with design o different type of file types is knows as Report rending. SQL Server Reporting Services supports multiple rendering extensions like Word, Excel, CSV, PDF, HTML etc.

Q: What are the different types of data sources in SSRS?
SSRS use different data source. Some of them are listed below.
  • Microsoft SQL Server
  • Oracle
  • ODBC
  • SQL Server Analysis Service
  • Report Server Model
  • SAP Net weaver BI
  • Hyperion
  • Teradata
  • XML

Q: What is the name of reporting services config file and what’s it’s used for?
Reporting service config file is used for report configuration details. It contains the report format and also the report import types. Report service config reside at ISS.

Q: What are Advantages of SSRS or why we should use SSRS?
The SQL Server Reporting Services or SSRS has some Advantages
  • It is faster and cheaper
  • Efficient reporting access to information residing in both Oracle and MS SQL Server databases
  • No need for expensive specialist skills
  • The default report designer is integrated with Visual Studio .NET so that we can create application and its reports in the same environmen
  • The security is managed in a role-based manner and can be applied to folders as well as reports
  • Once parameters are defined, the UI for these parameters is automatically generated
  • Subscription based reports are automatically sent by mail to the users

Q: What are the limitations/drawbacks or SSRS 2008 R2?
The SSRS 2008 R2 has some limitations. Some limitations are given below:
  • There is no print button. In order to print need to export excel, PDF or others format
  • It is very hard to debug expression or custom code
  • Its does not use page number or total pages in report body
  • Don’t support rounding rectangle
  • There is no way to pass values from sub-reports to main report
  • It is not possible to insert a sub-report into the page header or page footer
  • Page header creates extra spaces in the next pages

Q: What are the Export Options of SSRS?
SSRS allow many ways of rendering the reports:
  • Excel
  • Acrobat
  • Tiff (image)
  • XML
  • CSV

    Choose :
  • OR
  • To comment
No comments:
Write Comments