SSRS Interview Questions

Session 2 

• Types of reports in SSRS
• How to send same report data on basis of different country to different sheet in same excel?
• How to control number of rows on each page in SSRS
• How do you create multi select drop down/parameter? Without Allow multiple values option?
• How to create cascading parameters? Explain with a scenario in current project?
• What kind of export you worked in current project? 
• What are the Issues in exporting to excel or pdf? 
• How to set page names in exported copy? 
• How to set limit on page size while exporting? I.e. when exported, the page should contain only 50 rows. How do you achieve it? 
• What kind of reports you created?
• How do you do deployments in SSRS on current project? 
• What types of Expressions are using in current project?
• How to use 2 different dataset fields in single report?
• How to restrict a particular user not to see a particular report data?
• How to split and export report data into multiple excel sheets?
• Drill down and Drill through, Deployment types?
• How to get deployment permissions if you don’t have to do so?
• Explain about permissions on SSRS Reports?
• What was the chain -- how to give the permission -- permission action on user or URL?
• How will give permissions on URL's and Reports?   More ....