Remove Group based on Parameter 1

[lissa1974]

Hi there, using SQL with Crystal 2008. What I'm looking to do is remove a group based on the what's entered into a parameter. Currently I have data looking like this....

Item 1 Quality

Tops 2
Socks 3
Jeans 4

Item 2

Shoes 2
Hankys 3
Blankets 4

Item 3

Hats 2
Cains 3
etc.. 4

That's the default layout, all fine. However they may want to order it by quality, but keep the groups as they are....

Quality (Group I want to hide/show dependant on parameter)

2

Item 1

tops

Item 2

Shoes

item 3

Hats

3

Item 1

Socks

Item 2

Hankys

Item 3

Cains

etc....


Hope that makes sense?? So basically I want to remove a group altogether if a parameter says "NO".

Can this be done? Suppressing the groups no use as it still orders by that.

Thanks

 

[ianoctdec]

Hi Lisa,

Try this:

Create a formula to group on:

@Group1

if ?Parameter = 'Quality' then
table.quality
else
table.item

Dana