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 ....
Session
1
- What are the type of reports are available in
SSRS?
- What are the steps to follow to create the
Report?
- Different types of SSRS Reports
- What is Parameterized Reports?
- Difference between tabular and matrix
- Diff between drill down and drill through
- How to restrict rendering options in SSRS
- What are the uses of “Sub reports” in SSRS?
- How to hide Rendering options
in Report level & Group of Reports level
- In my system so many SQL Agent
jobs are running (SSMS), I want a report to show the job running status report
with all information?
- Drill through & Drill Drop
Reports
- What is Subscriptions? And
types in SSRS?
- Data driven subscriptions?
- Difference between report server and report manager
- What is the use of page breaks?
- What is bookmark in SSRS?
- What types are modes are included in report server installation? More ....
Project related
Questions:
- Explain the Roles
& Responsibilities on current Project?
- What is the day to day activates in your job?
- Which SDLC process is using in your project
(Water fall , Agile)
- Control flow components are using in current
project
- What kind of sql & BI tool in your current
project?
- What are the SSIS
Transformations are using in your project?
- How to Monitoring
the jobs on current Project?
- Incremental load
& Full load process following in working project
- What type of
Transactions on current Projects?
- Errors on your
Project and How to handle it?
- What are the visualizations worked in the project?
- Facing issues in current project?
