Learn more about SQL Server tools

 

Tutorials          DBA          Dev          BI          Career          Categories          Events          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Events

DBA    Dev    BI    Categories

 

SSRS Developer Interview Questions


By:   |   Read Comments (9)   |   Related Tips: More > Professional Development Interview Questions BI

Problem

Interview questions and practice tests are one of the quickest ways to evaluate one's knowledge on the subject area. In this tip, we have a list of SSRS Developer level interview questions that you can go through to refresh, evaluate and deepen your knowledge on SSRS development and take it to the next level.

Solution

Following are some general questions about SSRS development to see if general working knowledge of SSRS is known.

1) What are the different kinds of SSRS Reports?

  • Reports can be categorized into operational and analytical reports. The distinction is based on the source of data and level of analysis facilitated by any particular report. Operational reports are based on OLTP sources and are static reports and Analytical reports are based on OLAP sources and generally facilitate drill-down and drill-through for analysis. Technically, SSRS reports can be categorized into parameterized, linked, snapshot, cached, etc...
  • Further Reading

2) What are parameterized reports? What are cascading parameters in SSRS reports?

  • Reports that accept parameters from users to fetch and report data conditionally, are known as parameterized reports. When you have multiple parameters in a report and values of different parameters are dependent and populated dynamically based on the value of parent parameters, it's known as a cascading parameter.
  • Further Reading

3) How would you go about developing a SSRS report?

  • General development methodology for a SSRS report is to start by creating a data source. Based on the data source create one or multiple datasets as needed for parameters and the body of the report. Add required controls from the toolbox which would act as a container for the fields in the dataset. Format the controls added to the report body.  Verify and validate the report and finally deploy the report.
  • Further Reading

4) What is a dataset and what are the different types of datasets?

  • A dataset is similar to a query definition, which is executed when the report is executed. Datasets are of two types: Shared and Embedded. An embedded dataset is private to the report in which it exists and shared datasets can be shared across reports.
  • Further Reading

5) Would you store your query in a SSRS report or a Database server? State the reason why.

  • Storing SQL queries directly in text format in the dataset, should be avoided. Ideally it should be stored in a stored procedure in the database server. The benefit is that the SQL would be in a compiled format in a SP and brings all the benefits of using an SP compared to using an ad-hoc query from the report.
  • Further Reading

6) What is Tablix?

  • A Tablix can be seen as a control with combined capabilities of a table and a matrix, which facilitates asymmetric and flexible, row and column level, static and dynamic groupings.
  • Further Reading

7) How would you access SSRS reports deployed on report server?

  • Reports Manager is the most straight-forward way to access SSRS reports deployed on report server. Apart from executing the reports, it is the main administration console for SSRS server to manage reports.
  • Further Reading

8) Have you used the Report Viewer control / web part? What are the limitations?

  • The report viewer control / web part is the basic control to integrate SSRS reports with external applications. Using these interface applications can link and display SSRS reports within the application. The parameters toolbar in these controls have a limited programmable interface to decorate and blend it with the theme of the application.
  • Further Reading

9) Which is the latest version of SSRS and what are the new enhancements?

  • SSRS 2008 R2 is the latest RTM version of SSRS. Rich data visualizations, better programming functions for lookup and aggregation, improved performance and better control over exported data are some of the major enhancements.
  • Further Reading

10) What is Report Builder?

  • Report Builder is an ad-hoc report authoring tool primarily targeted to be used by business analysts to facilitate self-service report authoring. Report Builder 3.0 is the latest version available as of date.
  • Further Reading

11) How would you deploy SSRS Reports using out-of-box functionality and how can you automate SSRS report deployment?

  • Business Intelligence Development Studio is generally used to deploy SSRS reports. There is no out-of-box support in SSRS to automate reports deployment, but free third-party products like RSScripter can be used for this.
  • Further Reading

12) What is drill-down and drill-through in SSRS?

  • Drill-down is a mechanism of decomposing summarized information to a detailed level. Drill-through is a mechanism of decomposing the problem by drilling information generally using more than one report.
  • Further Reading
  • Further Reading

Next Steps
  • Interview questions can get more scenario based once you cover the general questions related to the product. So study SSRS controls in detail to have an inventory of features that you can use to solve a particular scenario or requirement.
  • Join MSDN SSRS Forums and review the questions posted to see if you can solve the problem to get more acquainted with real life requirements and challenges in SSRS development.


Last Update:





About the author
MSSQLTips author Siddharth Mehta Siddharth Mehta is an Associate Manager with Accenture in the Avanade Division focusing on Business Intelligence.

View all my tips
Related Resources





More SQL Server Solutions




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


Get free SQL tips:

*Enter Code refresh code     



Wednesday, March 23, 2016 - 4:01:41 PM - Pradeep Back To Top

This is great post. Thanks


Tuesday, August 04, 2015 - 7:25:19 PM - Bruno Tille Back To Top

2015-08-05: Please update: Business Intelligence Development Studio is now SQL Server Data Tools and RSScripter is not available anymore !


Tuesday, August 04, 2015 - 1:42:15 PM - Kris Maly Back To Top

Categorically speaking

Broadly

      Operational and Analytical reports

Operation

       Interactive and non-interactive Reports

Time variant Reports 

        Daily Reports, Weekly, Bi-weekly, Monthly annualy Reports

Types on Report frame

         Simple Report, Complex Report, Parameterized Report, Matrix Report, Dynamic Matrix Report,            

         SubReport, Linked Report


Sunday, June 29, 2014 - 11:49:44 AM - krismaly Back To Top

I enjoyed reading this page. dera Sid could you please publish some more. Especially Migrating from SQL Server 2008R2 to 2012 or 2014 Pros and cons. 

Migrating to 2012 and then 2014 or

2008R to 2014


Sunday, June 02, 2013 - 7:27:35 PM - Ned Bakelman Back To Top

 

This is awesome. Thank you very much.

 

Ned


Thursday, April 11, 2013 - 3:19:20 AM - ponraj Back To Top

Dear all,

 

We are facing problem in SSRS Matrix report while sum the Fields.it shows duplicate values, as well as report rendering time in front end takes

5mins for 600000 records though it runs in DB takes 51 seconds only.

 

Data set structure example

 

Schools                Rubric   Subjects               Ratings                 Score

101                         TCH        math’s                  H                            1

101                         TCH        Tamil                     H                            1

101                         TCH        math’s                  E                             2

101                         MED      math’s                  D                            1

101                         GUD      math’s                  U                            3

 

WE NEED TO SUM THE RATINGS SUM LIKE

SCHOOL               => Rubric =>Subjects=>H             =SUM (SCORE)

SCHOOL               => Rubric =>Subjects=>E              =SUM (SCORE)

SCHOOL               => Rubric =>Subjects=>D             =SUM (SCORE)

SCHOOL               => Rubric =>Subjects=>U             =SUM (SCORE)

 


Tuesday, January 22, 2013 - 5:42:44 PM - Jignesh Back To Top

Hey Siddhu,

Can you please tell me the situation where we need to integrate it with web application. I know SSRS but i want to go one step further and i would like to know in which scenario we can integrate SSRS with ASP.NET web application.


Wednesday, January 02, 2013 - 9:44:48 AM - Mark Tassin Back To Top

5) Would you store your query in a SSRS report or a Database server? State the reason why.

  • Storing SQL queries directly in text format in the dataset, should be avoided. Ideally it should be stored in a stored procedure in the database server. The benefit is that the SQL would be in a compiled format in a SP and brings all the benefits of using an SP compared to using an ad-hoc query from the report.

 

This is not true.  A Stored procedure is not stored in compiled form in the plan cache until it is executed the first time.  A query stored in a report will be compiled and stored in the plan cache when the report runs said query.  If the query is parameterized then the plan will be reused the next time the report is run if the query plan hasn't expired out of the cache.

http://www.scarydba.com/2009/09/30/pre-compiled-stored-procedures-fact-or-myth/

That said, for code re-use stored procedures are awesome.  For creating them to make the database logic self-contained within the database and applications making calls into the database through them as if they were api methods is also very useful.


Wednesday, December 05, 2012 - 1:10:47 PM - Feather Back To Top

Great questions!


Learn more about SQL Server tools