Group by a run-time parameter 2

[johnstrang]

Hi,

Using CR 8.5 with a direct connection to an Oracle database.

I have a run-time paramater {?TEAM} and would like to be able to have a report on with 2 groups:
1. DEPARTMENT_NAME = {?TEAM}
2. Others

I have tried using a formula as group name, but the parameter field is not available.

Is it possible to do what I want?

Many thanks in advance to anyone who replies

John

 

[chelseatech]

Create a formula of
If {table.Dept}={?Team} then {?Team} else "Others"

You should be able to group by this formula.


Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[lupins46]

I think you are on the right lines.
You need a parameter field to get the team name.
You need a formula field to derive a value which can be used for grouping.

The formula field would be :

if {mytable.department_field}={?Team1} then
" " & {mytable.department_field}
else
"Others"

Then group on this formula field.

The extra leading space is to force the selected value to appear before 'others' in the grouping sequence.

 

[johnstrang]

Thanks to chelseatech and lupins46 - their suggestions worked perfectly.

I'm now annoyed with myself because I should have known how to do this without asking, but my mind went blank. (Maybe I should say I was too busy with so many other tasks.......)

John