Re: Another Report's Question

The problem is that Reports thinks it may have several occurrences of the value to put in the margin field, 1 for each row the query returns. Assuming there can only be 1 distinct value of a_xxx, returned by the query, you can solve it by creating a summary column, sourced by the column a_xxx, at Report level. As this summary column only occurs once you can use it as the source for your margin field. If you create a 'first' summary, this will have the same value as that returned by the query. Obviously this wouldn't work if you had more than 1 row returned by the query.

agi_at_mail.taicom.com.tw wrote in message
>Hi,theres
> When I implement a group above (master-detail) report,I have a problem
>to add a field in the margin.
> The field is from a simple querry( last query of the report) like
>select a_xxx from a_table. When I run it,I got a REP-1213-field_5
>references column 'a_xxx' at a frequency below its group.
>
> How to achieve my goal( add a field in the margin)?
>
Received on Mon Jun 07 1999 - 13:57:48 CEST