Using the Report Model Wizard

The Report Model Wizard prompts you to select a DSV, to choose the report model generation rules to apply, and to specify whether to generate or update model statistics. You can use only one DSV as input for the wizard. In general, you should keep the default report model generation rules until you understand better how rules affect the structure of the report model. The wizard stores cardinality information and the distinct count of instances for each column in the DSV as model statistics and then uses the model statistics to set properties for model objects. For example, if a table has a high number of unique instances, the corresponding InstanceSelection property in the report model is set to a value that forces ...

Get Microsoft® SQL Server® 2008 Reporting Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.