This post will be helpful to all the SSRS
Developers who are looking for change or wanted to build their carrier in SQL
Server Reporting Services.
Below interview questions will help you out to
crack interviews in SQL Server Reporting Services irrespective of how much
experience you have
- What is the difference between SSRS 2005, SSRS 2008,2012, 2014 & SSRS 2016?
- What is Sub Report, How to Pass Main Report Parameter to sub Report?
- What is Dashboard, how to create Dashboard in SSRS ?
- Explain what is the difference between Tabular and Matrix report?
- What is the difference between Drill Down and Drill through Report?
- How many ways you can deploy a Report in Report Server?
- What is difference between Report Server in Native Mode vs Report Server in Share point mode?
- What is Report Server db and Report Server temp DB?
- What is the difference between IIF and Switch condition?
- How to apply Alternate Colour on Rows in SSRS?
- Can we write custom code in SSRS ? IF yes then why and where we can write?
- What is Linked Report and its usage?
- What is the difference between Report Server and Report Manager?
- Difference between Query Parameter and Report Parameter?
- What is the use of list in SSRS with an example ?
- What is caching and Snapshot in SSRS, what is the difference between them?
- What are subscriptions and Type of subscriptions?
- How to find longest running Reports ?
- How to debug Reports which are taking lots of time to Preview?
- What is cascading of Parameters in SSRS?
- Does changing the Parameter order will affect the Report ?
- Report builder and it’s usage ?
- Difference type of charts in SSRS, Can we plot secondary Y axis in the chart?
- What are the different types of data sources in SSRS?
- What is document map in SSRS?
There are lots of other questions also that an Interviewer can ask these are just the common question in most of the companies.Hope these questions will help you out.All the best.
Note: For Interview Question on SQL Server Read my Previous Post- http://www.sqlandssrssolutions.com/2016/06/interview-questions-on-sql-server.html
