Grouping in Labels

[Sheri]

I have a label such as:

Aliquot number
Test name
metal1
metal2
metal3

The labels are grouped by Aliquot number, then by test name. The tests for
metals have metals listed under them. I need to move the metals in line
with the test name, like this:

Aliquot number
Test name metal1 metal2 metal3

Is there a way to do this?

Thanks a lot,
Sheri

[Chris Werner]

Hi Sheri,

I've found a POSSIBLE solution for
you this morning in another thread:

Delete all columns from the detail band and
place a computed expression named 'metals' right from
the 'test_name' column in the header of
group 2. The expression is like this:

if( test_name <> test_name[-1],
metal,
describe( "evaluate('metals', " + string(getRow() - 1) + ")" ) + " " +
metal
)

Make sure that the computed expression
is big enough for the maximum number
of metals in a group. Maybe the expression
must also find changes of Aliquot numbers
where the same test name arises in two
subsequent rows:

if( test_name <> test_name[-1] or aliquot_nr <> aliquot_nr[-1],
metal,
describe( "evaluate('metals', " + string(getRow() - 1) + ")" ) + " " +
metal
)

You have to change the names 'aliquot_nr',
'test_name' and 'metal' to fit the column names
used in your report.

--
Chris Werner

<Sheri> schrieb im Newsbeitrag
news:4A15B1FFC9DD98BD00747A7385256D6C.00747A8385256D6C@webforums...