Tuesday, June 28, 2011

SSRS Interview Questions

Q1. WHAT is SQL Server Reporting Services(SSRS)?
SQL Server Reporting Services is a server-based reporting platform that you can use to create and manage tabular, matrix, graphical, and free-form reports that contain data from relational and multidimensional data sources. The reports that you create can be viewed and managed over a World Wide Web-based connection

Q2. Architecture of SSRS:

Q3. What are the three stages of Enterprise Reporting Life Cycle ?
a. Authoring
b. Management
c. Access and Delivery

Q4. What are the components included in SSRS?
1. A Complete set of Tools that can be used to create, manage and view reports
2. A Report Server component that hosts and processes reports in a variety of formats. Output formats include HTML, PDF, TIFF, Excel, CSV, and more.
3.An API that allows developers to integrate or extend data and report processing in custom applications, or create custom tools to build and manage reports.

Q5. What is the benefit of using embedded code in a report?
1. Reuseability of Code: function created in embedded code to perform a logic can be then used in multiple expressions
2. Centralized code: helps in better manageability of code.

Q6. Which programming language can be used to code embedded functions in SSRS?
Visual Basic .NET Code.

Q7. Important terms used in the reporting services?

1. Report definition:  The blueprint for a report before the report is processed or rendered. A report definition contains information about the query and layout for the report.

2. Report snapshot: A report that contains data captured at a specific point in time. A report snapshot is actually a report definition that contains a dataset instead of query instructions.

3. Rendered report: A fully processed report that contains both data and layout information, in a format suitable for viewing (such as HTML).

4. Parameterized report: A published report that accepts input values through parameters.

5. Shared data source: A predefined, standalone item that contains data source connection information.

6. Shared schedule: A predefined, standalone item that contains schedule information.

7. Report-specific data source: Data source information that is defined within a report definition.

8. Report model: A semantic description of business data, used for ac hoc reports created in Report Builder.

9. Linked report: A report that derives its definition through a link to another report.

10. Report server administrator: This term is used in the documentation to describe a user with elevated privileges who can access all settings and content of a report server. If you are using the default roles, a report server administrator is typically a user who is assigned to both the Content Manager role and the System Administrator role. Local administrators can have elevated permission even if role assignments are not defined for them.

11. Folder hierarchy: A bounded namespace that uniquely identifies all reports, folders, report models, shared data source items, and resources that are stored in and managed by a report server.

12. Report Server: Describes the Report Server component, which provides data and report processing, and report delivery. The Report Server component includes several subcomponents that perform specific functions.

13. Report Manager: Describes the Web application tool used to access and manage the contents of a report server database.

14. Report Builder: Report authoring tool used to create ad hoc reports.

15. Report Designer: Report creation tool included with Reporting Services.

16. Model Designer: Report model creation tool used to build models for ad hoc reporting.

17. Report Server Command Prompt Utilities: Command line utilities that you can use to administer a report server.
a) RsConfig.exe, b) RsKeymgmt.exe, c) Rs.exe

Q8. what are the Command Line Utilities available In Reporting Services?
· Rsconfig Utility (Rsconfig.exe): encrypts and stores connection and account values in the RSReportServer.config file. Encrypted values include report server database connection information and account values used for unattended report processing
· RsKeymgmt Utility: Extracts, restores, creates, and deletes the symmetric key used to protect sensitive report server data against unauthorized access
· RS Utility: this utility is mainly used to automate report server deployment and administration tasks.Processes script you provide in an input file.
Q. How to know Report Execution History?
ExecutionLog table in ReportServer database store all the logs from last two months.
 SELECT * FROM ReportServer.dbo.ExecutionLog

Q. What is difference between Tablular and Matrix report?
OR What are the different styles of reports?

Tablular report: A tabular report is the most basic type of report. Each column corresponds to a column selected from the database.

Matrix report: A matrix (cross-product) report is a cross-tabulation of four groups of data:
    a. One group of data is displayed across the page.
    b. One group of data is displayed down the page.
    c. One group of data is the cross-product, which determines all possible locations where the across and down data relate and places a cell in those locations.
    d. One group of data is displayed as the "filler" of the cells.
Martix reports can be considered more of a  Pivot table.

Q. How to create Drill-through reports?
Using Navigation property of a cell and setting child report and its parameters in it.

Q. How to create Drill-Down reports?
To cut the story short: 
- By grouping data on required fields
-Then toggle visibility based on the grouped filed

Q. How to select ALL from a parameter list?

(Work in progress, more to follow)


Anonymous said...

Thats a very gud post,

Prashanth (http://techfunk.blogpostcom)

Anonymous said...

Nice post

Anonymous said...

Nice post Buddy
Jeevan (http://topictolearn.blogspot.com/)

Bill Ross - Premier Eye Care said...

Awesome. Thanks!

Anonymous said...

Nice post. Good for starters.

Anonymous said...

Awesome, thanks!

Anonymous said...


SSRS interview questions said...

nice questions. Very comprehensive list covering quite a lot of SSRS topics.

R.A.M KuMaR said...

Its really very useful questions..

Anonymous said...

Nice Questions.
Covers lot of topics.


Anonymous said...

thanks a lot!! Excellent collections

Anonymous said...

Good Job!

Aamir Shahzad

Shubhangi Tambe said...

It's very useful. Thanks.

Domain KING said...

Thank you for such a wonderful Information !!

Veritas Cluster Interview Questions

SAMBA Server Interview Questions

Linux FTP vsftpd Interview Questions

SSH Interview Questions

Apache Interview Questions

Nagios Interview questions

IPTABLES Interview Questions

Ldap Server Interview Questions

LVM Interview questions

Sendmail Server Interview Questions

YUM Interview Questions

NFS Interview Questions

Read More at :- Linux Troubleshooting

Michael Hussey said...

Great Blog Thanks.

Here You Can Find Your First Round Intreview question For Job .

SSRS interview questions

Vamshi Krishna said...

Thanks for posting such an interesting inforamtion, Please keep updates us and make us up to date....

Karthika Shree said...

This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
Embedded Training in Chennai

Elena Lauren said...

Great Post..! If you are looking for indepth SSRS Interview questions, please visit here: https://goo.gl/dhMyuR. We provide Online training, live projects, tutorials and job support too.

Gabe Co Hadwin said...

This is an amazing blog,it gives very helpful messages to us.Besides that Wisen has established as Best Dot Net Training in Chennai. or learn thru ASP.NET Online Training . Nowadays Dot Net has tons of job opportunities on various vertical industry.

hariprasad p said...

Thanks for sharing the great information about MSBI… Its useful and helpful information…Keep Sharing.

priya Eeranagula said...


I have read your MSBI blog.It"s very attractive and impressive. I like it your blog.

Yng Yng said...

thank you

MSBI Job Support said...

Excellent and decent post, I found this much informative, as to what I was exactly searching for. This blog post has a bundle of knowledge for job seekers. Thank you for sharing this with us.

Cognos Training said...

Very good post.
All the ways that you suggested for find a new post was very good.
Keep doing posting and thanks for sharing.
cognos training in hyderabad

Techtoolsinnovation said...

Thank you so much for sharing such an awesome blog...
data science training
training and job placement services

soumya Teja said...

This blog is simply superb I really liked it, Thanks for sharing more valuable information with us MSBI Online Training Hyderabad

Gopal Ainavalli said...

Great Article… I love to read your articles because your writing style is too good.


Peter Johnson said...

Awe! What An Blog Very Helpful and interesting Really A great center for acquiring knowledge.Very Helpful Post And Explained Very Clearly About All the things.Very Helpful. Coming To Our Self We Provide Restaurant Equipment Parts .Really Thankfull For the blogger providing such a great information.Thank you. Have a Nice Day.

seo said...

The Best Blog I Have Seen in the recent times Providing quality information about online it courses,we provide Urgent Care Services in chicago.Thanks For Sharing knowledge With Us.Really Thanks for Posting.

Lathika Honey said...

The information you provided in the article is useful and beneficial US Medical Residency Really Thankful For the blogger providing such a great information. Thank you. Have a Nice Day.

Sneha rathod said...

Very nice post! thanks for providing your information. Get more knowledge on Data Science online Training

Lathika Honey said...

This Blog Provides Very Useful and Important Information. I just Want to share this blog with my friends and family members. Tibco Certification Training

Post a Comment