What do you mean by Cascaded Parameterised Reports?

1.	What do you mean by Cascaded Parameterised Reports?
Answer» Reports with MANY parameters are known as cascaded parameterized reports. Some parameters, on the other hand, will have values or value sets that are DEPENDENT on other parameters. The order of the parameters can affect the report's optimization. For example, if we have a million results for a customer parameter, we MAY filter it by ADDING a GENDER parameter first, which will cut the customer parameter results in half. We have a subcategory parameter, for example, but its values aren't filled in until the category parameter is selected.

Answer»

Reports with MANY parameters are known as cascaded parameterized reports.

Some parameters, on the other hand, will have values or value sets that are DEPENDENT on other parameters. The order of the parameters can affect the report's optimization. For example, if we have a million results for a customer parameter, we MAY filter it by ADDING a GENDER parameter first, which will cut the customer parameter results in half. We have a subcategory parameter, for example, but its values aren't filled in until the category parameter is selected.

Discussion

No Comment Found

Related InterviewSolutions

Differentiate between SQL Server Reporting Services and Power Bi.
What do you mean by Cascaded Parameterised Reports?
How can you send a SSRS report from SSIS?
What do you mean by RDL in the context of SQL Server Reporting Services (SSRS)?
What are the use cases of Snapshot reports in the context of SQL Server Reporting Services (SSRS)?
What are the advantages and disadvantages of using SQL Server Authentication?
Explain the different authentication modes for a database engine.
What do you understand by logical pages in SQL Server Reporting Services (SSRS)?
What do you understand about physical pages in SQL Server Reporting Services (SSRS)?
What things should you keep in mind while creating paginated reports in SQL Server Reporting Services (SSRS)?