Suppress everything in report by a group name 1

[Cpreston]

Hi

I have a report that is running form a view in SQL.

I have a few groups but the main group is by Vehicle Name.

We have

Own Collection
Own Artic
3rd party
Other

I want the group to supress all figures in all of the report if the group is Own Collection.
So none of the other group level show, or details and it is not included in any of the formula totals

Is this possible to do in one place. I currently have the main group level set as Suppress (No Drill Down) and the formula set to

if GroupName ({@type}) = "*Own*"
then True
Else
False


This gets rid of the name but leaves all other details there.

Any ideas please (I know I could re-write the view in SQL to not include it but then this is sued elsewhere so I would have to create a new view, link it back to this report and then practically start all over again.

Thanks

 

[CrystalizeCanada]

[pre]Report, Select Expert, Record...[/pre]

{@type} <> 'Own Collection'

or

not ({@type) like '*Own*')

A record selection formula will filter out records (and consequently groups) based on the {@type} formula.
If {@type} is not available for Record Selection (this can be the case if the timing of the formula prevents it from being available) then you can use a Group Selection formula instead.

[pre]Report, Select Expert, Group...[/pre]
Use the same formula for group selection as you would for record selection

If you end up using a Group Selection formula you may notice that Grand Totals still include values from the 'Own Collection' group. If you wish to exclude these records a Running Total can be used as a substitute to the Grand Total.

Gordon BOCP
Crystalize

 

[Cpreston]

Hi

Yes this works but it still appears to calculate the figures for it in the grand totals

Thanks

 

[CrystalizeCanada]

If you have to use a Group Selection formula (instead of a Record Selection formula) then yes that is the case - Grand Totals will include values from that group.

See note from previous post below:
If you end up using a Group Selection formula you may notice that Grand Totals still include values from the 'Own Collection' group. If you wish to exclude these records a Running Total can be used as a substitute to the Grand Total.


Gordon BOCP
Crystalize

 

[Cpreston]

Hi

Sorry should read things more carefully, been a long week. Works great, thanks for the help and reply's

 

[Cpreston]

Hi

Sorry ran into another issue related to the groups which I cannot figure out. Each of the groups as a date field next to it. I have used this as a count but the grand total count still includes the - Own Collection count. I need the count to work out an average so need the own collection count to not be included.

Any ideas please

Thanks

 

[Cpreston]

Its ok using a running count, seems to work.