Preview Content - log in or become a member

SSRS Interview questions and answers

SQL Server Reporting Services skills are required in more and more IT jobs. If you need to interview someone and you need to assess candidate SSRS skills below are some example of questions. Feel free to suggest so other good SSRS Interview questions and answers, we are happy to include them in our blog post.

NOTE: We will cover SSRS 2008 R2 which should be applicable to 2008 & SSRS 2012.

Who is it for?:

  • People doing SSRS Interviews (face to face or over the phone)
  • Recruiters trying to check the candidate's proficiency with SSRS
  • Candidates who can prepare better for the interview (You won't get explicit answers here)

Content:

List of SSRS interview questions:

If you want to answer the question first without our answers feel free to use the list here. Later in the our blog post you will see both question and answers.

NOTE: Answers show our experience in specific type of projects and SSRS is one of the tools that can be used in many different ways so you might get very different opinions to our answers. So it is up to you to decide if our answer is suitable to your situation.

Question: Which versions of SSRS have you used?

Question: Have you got samples of your work?
Question: Do you have Data Visualization skills? (optional)
Question: How have you learnt SSRS (on the job, articles, books, conferences)
Question: How do you normally create reports (wizard/manually)?
Question: What languages have you used to query data for SSRS Reports?
Question: Gives examples where you used parameters?
Question: What types of graphs do you normally use and what effects do you apply to them?

Question: Have you used custom assemblies in SSRS? If Yes give an example
Question: Can you update report data using SSRS?
Question: What is the formatting code (format property) for a number with 2 decimal places?
 

Below are "narrowed" questions:

Question: What does rdl stand for?

Question: How to deploy an SSRS Report?

Question: What is Report Manager?

Question: What is Report Builder?

Question: What permission do you need to give to users to enable them to use Report Builder?

Question: What do you need to restore report server database on another machine?

Question: Can you create subscription using windows authentication?

Question: What caching options do you have for reports on report server?

Question: How to find slow running reports?

Question: How can you make calendar available in report parameter?

Question: How to pass multi-valued parameter to stored procedure in dataset?

Question: Which functions are used to pass parameter to MDX query?

Question: How to create "dependent " parameter "Make, Model, Year"

Question: How to create "alternate row colour"?

Question: How to create percentile function?

Question: How to create median function?

Question: How to make conditional sum in SSRS?

Question: How to find a value in another dataset based on current dataset field (SSRS 2008 R2)?

Question: How to change parameter value inside the report?

Question: How to identify current user in SSRS Report?

 

General SSRS Questions

Question: Which versions of SSRS have you used?
Comment: Differences between 2005 and 2008 are quite big so if someone hasn't used 2008 or 2008 R2 before (or vice versa) than make sure you know this will require a few days to get up to speed with the new/previous version. If the candidate used several versions ask to describe the differences between them.

Question: Have you got samples of your work?

Are you a member? Log In

Membership plans from just 6.00 USD*

* Currency: USD (US Dollar )
2500+ accounts so far

Plans:
Bronze
6.00 USD
Silver
9.00 USD
Gold
12.00 USD
6 Courses
T-SQL (3), SSRS (1), SSIS(1), Excel (1)
Watch Video
75 Mini Courses
T-SQL (34), SSRS (7), SSIS(16), + more
300+ videos and 300+ Articles
38
(part of
Courses)
Progress Tracking
21 Interview Q&As pages
T-SQL (8), SSRS (3), SSIS(4), Other (6)
Forum
11 Webinar Recordings
T-SQL (1), SSRS (9), Career(1)
1 DIY Project (beta)
70-461 Tests
Watch Video
60 days, 100% Money Back Guarantee
Instant Activation
Duration:
Bronze
Silver
Gold
Valid for: 1 month 6.00 USD
sign up
9.00 USD
sign up
12.00 USD
sign up
Valid for: 3 months
10% off
16.00 USD
sign up
24.00 USD
sign up
32.00 USD
sign up
Valid for: 6 months
20% off
28.00 USD
sign up
43.00 USD
sign up
57.00 USD
sign up
Valid for: 1 year
30% off
50.00 USD
sign up
75.00 USD
sign up
100.00 USD
sign up
Valid for: 2 years
40% off
86.00 USD
sign up
129.00 USD
sign up
172.00 USD
sign up
Valid for: lifetime
50% off
108.00 USD
sign up
162.00 USD
sign up
216.00 USD
sign up


Did you find this page useful?
+5  |  -0
(5 Votes)