removing groups from report on parameter decision

[charlieintegral]

Hi, I'm using CR9 on an oracle DB. not sure if this is possible. I am writing a report which has many groups. The final group gives a lot of detail, but I want the report to be able to remove the second from last group on end user selection (through a parameter I'm assuming) and still give the data.

e.g.:-


gp4 24
gp5 11
gp6 z 2
gp6 x 3
gp6 w 6
gp5 13
gp6 z 4
gp6 x 5
gp6 w 4

I want, on end user choice, the ability to remove the group 5 but still add up the gp 6 totals, but not have group 5 totally removed for the report as another end user might want the data to detail more (gp 5)

gp4 24
gp6 z 6
gp6 x 8
gp6 w 10

Just by using the CR9 program I can just delete gp5 and this works and then hitting the undo button, I'm back to the original report, but this needs to be published

any ideas?

__.____._

 

[IanWaterman]

YOu will need to use a formulae to replace groups 5.

@Grp5
If param = true then grp5field else grp6field

In section expert suppress group 6 if parameter condition = false.

Ian

 

[lbass]

Or you could use a formula like this for group 5:

if {?Parameter} = "Include Group 5" then
{table.group5field}

This assumes the groupfield is a string. Format the Group #5 sections to "suppress blank sections".

-LB

 

[IanWaterman]

LB

Learn something new every day. I always thought that a Group had to be defined. So much easier doing it your way!!

Ian

 

[charlieintegral]

thanks everyone. worked a treat!!