to subreport or not

[atarrqis]

CR8.5 and Oracle
Purchase Order = order_no
line_no part_no description spec_text
1 123 assembly requires xyz
2 paper
3 456 2nd assembly requires xyz

only one group - order_no
if part_no is null, spec_text will be null
if part no is not null, spec_text will be the same for every part on that order.
I want to print spec_text only once, in group footer. If
last part_no is null, spec_text wil be null so nothing prints. I know I can get around this using a subreport but I'm wondering if there is a smarter way.
Thanks.

 

[synapsevampire]

Still a bit vague.

If you're only printing the spec_text once, and it has different spec_text, what is to be printed?

Anyway, one solution might be a formula, as in:

maximum({table.spec_text}, {table.order})

Place it in the group footer and the maximum spec_text will print.

-k

 

[synapsevampire]

btw, this formula will also work for display in the group header if you prefer.

-k

 

[lbass]

You don't even need a formula--you could just right click on {table.text} and insert a maximum at the group level.

-LB