REPORT BUILDER

Report Builder is a report authoring environment for business users who prefer to work in the Microsoft Office environment. When you design a report, you specify where to get the data, which data to get, and how to display the data. When you run the report, the report processor takes all the information you have specified, retrieves the data, and combines it with the report layout to generate the report.

Report Builder enables you to:

·         Use the Report Builder ribbon to quickly add items your reports, launch table, chart, and map wizards, and format report data.

·         Add data from built-in data providers by using query designers that help you specify which data to include in your report.

·         Create and use report parameters and other interactive features that enable your report readers to customize data and vary report presentation.

·         Create expressions from built-in fields, collections, operators, and functions.

·         Open reports directly from a report server.

·         Preview reports that use local or published shared data sources and shared datasets.

·         Preview reports in HTML or print format.

·         Export reports to other file formats such as Microsoft Excel.

·         Save your report and related items s to a SharePoint library, a report server, or your local computer.

Taken from the Microsoft TechNet website...

 

SSRS INTERVIEW QUESTIONS