SSRS INTERVIEW QUESTIONS part-2

What is the report rendering?

Report rendering is to call the report from server to application. Report rendering can be possible through different ways Like

Excel, PDF, CSV,XML, TIFF, HTML Web Archive,DOC

 What is the report server?

Report server is the server where we deploy the report In Other way it’s a holding place for reports. Applications access report server to view the report.

All the reports are reside with Report Server All other activities pertaining to SSRS is done at Report Server.It acts like work station for reporting tool.

Can we use the page total in report body?

The built in field [&pagenumber] and [&pagetotal] cannot be used in report body as these are applicable in report header or report footer.

These built in field can be added in footer or header for better representation of the report.

What are the different types of report?

Using BIDS reports can be created in two ways. I.e. two ways to retrieve the data from SQL Server data source.

1. TSQL Reports: TSQL Reports are made up of plain SQL Query. Data source in this case is SQL server database engine.
2. MDX Reports: MDX reports are created through cubes. For this data source is analysis services cubes.

What is report subscription? 

Report subscription is to schedule the resource on particular time and to send a mailer to particular users. A subscription is a standing request to deliver a report at a specific time or in response to an event, and then to have that report presented in a way that you define. Subscriptions provide an alternative to running a report on demand. On-demand reporting requires that you actively select the report each time you want to view the report. In contrast, subscriptions can be used to schedule and then automate the delivery of a report. 

What is the RDL file?

      A report definition contains data retrieval and layout information for a report. Report Definition Language (RDL) is an XML representation of this report definition.

What are the Matrix reports and what are their uses?

Matrix reports are the reports which used to generate data dynamically i.e. table structure is not static and it can be changed at run time.

Can you use a stored procedure to provide data to an SSRS report?
Yes, you can use a stored procedure to provide data to an SSRS report by configuring the dataset to use a stored procedure command type. However, your stored procedure should return only a single result set. If it returns multiple result sets, only the first one is used for the report dataset.

What is the main purpose of a report parameter?
The main purpose of a report parameter is to add interactivity to your reports, letting users change the report behavior based on options they select. The report parameter option allows you to show different dimensions in a single report by selecting the options.

What is the main purpose of a query parameter?
The main purpose of a query parameter is to filter data in the data source.