SSRS Interview Question

1. What programming language would you use to create embedded functions in SSRS?
   visual Basic .Net used to create  embedded code in SSRS
2. What is the purpose of query parameter in ssrs?

Query parameter is used to filter the data in data source

3. What is the main difference between a Matrix report item and a Table report item? 

              both report items are just templates for the Tablix data region.            tabular report is the most basic type of report. Each column corresponds to a column selected from the database. A matrix (cross-product) report is a cross-tabulation of four groups of data: a. One group of data is displayed across the page

4.      What is the benefit of embedded code in the ssrs  reports?

Once we write the code in reports we can use the code in any expression in that report.

5.      How to display the amount in currency format and for that which property do you use?

For currency format in ssrs reports select the report item and then set the format property to  C.

6.      Can you use stored procedures in ssrs reports to get the data?

Yes, we can use stored procedures in ssrs reports and it should return only a single result.

7.      By which  we can use to generate reports in ssrs?

Reports can be developed by using tables,cubes,textfiles etc.,

8.      What is .rdl file?

Every report saved with .rdl extension in reporting services. RDL means Report Definition  Language.

9.      How many types os parameters in ssrs reports?

Single value parameters, multi value parameters, cascading parameters

10  what are the different stages in ssrs report processing

     Compile, process,render and export

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.