embed - header vs detail

[Bryan Gardner]

I have an embed that works just fine in the detail section, but when I move
it to header it stops retrieving. Is this normal?

I want to select the drawing_number (column) from crqt_drawings (table)
where crqt_drawings.parent_key = :master_key (retrieval argument), but only
if there is one record.

I used a computed column, but run into problems of course when there is more
than 1.

[John Olson [Team Sybase]]

If the dw relies on the detail row for it's argument then it will only
retrieve properly in the context of the detail band. In your case it sounds
like you are just passing the master retrieval argument through to the
embedded report. If true, it should work. Did you try putting it in the
footer just to see if it would work? You could also try creating a group and
put it in the group trailer.

Regards,
John

Post by Bryan Gardner
I have an embed that works just fine in the detail section, but when I move
it to header it stops retrieving. Is this normal?
I want to select the drawing_number (column) from crqt_drawings (table)
where crqt_drawings.parent_key = :master_key (retrieval argument), but only
if there is one record.
I used a computed column, but run into problems of course when there is more
than 1.