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