Sub Reports is the reference to other report which opens in main report when main report loads.
In sub report you can pass parameter to the report which you want to view.
Sub reports can also be added to dynamic rows or columns in a table or matrix. When the main report is processed, the sub report is processed for each row.
Advantage of sub reports:
Can open the report in main window.
Can be helpful in creating dashboards whereas summary report can be displayed in sub report that can be later drill down reports to view detailed information.
In sub report you can pass parameter to the report which you want to view.
Sub reports can also be added to dynamic rows or columns in a table or matrix. When the main report is processed, the sub report is processed for each row.
Advantage of sub reports:
Can open the report in main window.
Can be helpful in creating dashboards whereas summary report can be displayed in sub report that can be later drill down reports to view detailed information.
Key Word : SQL Server Interview Question, SSRS Interview Questions and Answers.
No comments:
Post a Comment