report builder aggregates

Is there anyway to control which aggregates are displayed in Report Builder? Failing that can I turn them off by table or all together.

Thanks.

You have a couple of different options.

1. Turn them off when autogenerating. There are two checkboxes; one for autogenerating count aggregates and one for date aggregates.

2. Delete the ones you know you don't want. I tend to do this with numeric columns that I know are keys or IDs.

3. By default, the Total aggregate is the displayed value in the model. You can disable this behavior in properties of the column, "DefaultAggregateAttribute". Make in "(none)". I spend alot of time making sure my entities are in alpha order so that they are easier to find. This cleans up the look of the final model.

4. Hide the aggregate. I find this one the most useful. You never know when you may be asked to make it re-appear.

R

|||Thanks!

Quick questions. On which screen are these checkboxes, I haven't seen them. Also where would you hide an aggregate?|||

When you run the Autogenerate wizard, the third screen in has mulitple checkboxes for what you want to generate. If you are like me, you just "Next->" on through them. There are some nice options in there.

The hidden property is available on every item in the model. Show the properties window, select the item(s) you want to hide and change the "Hidden" property from False to True.

R