SSRS Interview Questions II

1. What does rdl stand for?
    RDL stand for Report Definition Language. RDL is the extension for reports file.

2. What is Report Manager?
    Report Manager is a web based tool that allows to access and run reports.

3. What is Report Builder?
    Report Builder is a self-service tool for end users

4. What permission do you need to give to users to enable them to use Report Builder?
    "Report Builder" role and "system user". Report builder should also be enable in report server properties

5. What do you need to restore report server database on another machine?
    SSRS Encryption key

6. How to pass multi-valued parameter to stored procedure in dataset?
    Join function in SSRS and split function in T-SQL

7. How to create "dependent" parameter "Make, Model, Year"
    They need to be in correct order, and previous parameter should filter next parameter dataset. For instance Model dataset should be filtered using Make parameter

8. How to create "alternate row colour"?
    IIF(ROWNUMBER(NOTHING)%2=0,"White","White Smoke")

9. How to create percentile function?
    Custom code is required for this
    Code : 
       Public Function Percent(ByVal CurrVal As Long, ByVal MaxVal As Long) As Decimal
                 If CurrVal = 0  or MaxVal = 0 Then
                       Return 0
                 Else
                       Return (CurrVal / MaxVal * 100)
                 End If
        End Function

10. How to find a value in another dataset based on current dataset field (SSRS 2008 R2)?
      using lookup function
      Example : =JOIN(LookupSet(Fields!DepartmentID.Value, Fields!ID.Value, Fields!Name.Value, "Departments"),","

11. How to identify current user in SSRS Report?
      User!UserID

12. What is the shared data source in ssrs?
      A shared data source is a set of data source connection properties that can be referenced by multiple reports, models, and data-driven subscriptions that run on a Reporting Services report server. Shared data sources provide an easy way to manage data source properties that often change over time. If a user account or password changes, or if you move the database to a different server, you can update the connection information in one place.

Shared data sources are optional for reports and data-driven subscriptions, but required for report models. If you plan to use report models for ad hoc reporting, you must create and maintain a shared data source item to provide connection information to the model.

13. What is the report rendering?

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