Re: Query Bug?

[Jim Langston <jlangston@xxxxxxxxxxxxxxxx>]

Sounds to me like your report is summary only.  On a
summary only report only the fields with sub totals will
show up.

I had this exact same problem with something I was doing.
My solution was simple, make FLDA a break field.  Since
it was a break field, it would show up on the report.  In my
case there was always one unique FLDA for each FLDB,
so I could get away with it (FLDA was customer number,
FLDB was customer name.  Breaking on FLDA or FLDB
only and the other wouldn't show up. Break on both, and
they both showed up).

A side effect of this, however, was I now received 2 lines
for each customer instead of only one.  One for the FLDA
break and one for the FLDB break.  I lived with it.

Another option you might be able to do.  In my case I could
of created a CALC field that was simply FLDA || '   ' || FLDB
and break on this.  That way I would of only gotten one break
per combination.

Regards,

Jim Langston

Eric Kempter wrote:

> I am writing a query on a file and have selected and sequenced in ascending 
>order FLDA, FLDB, FLDC, and FLDD.  There are other fields in the file that I 
>have not selected.   The sort is the same.  I am counting FLDC and FLDD.  I 
>have specified breaks on FLDB, FLDC, and FLDD.
>
> Result:  FLDA does not print on the report.  FLDB, FLDC and FLDD do.  Bug?  
>If I add FLDA to the specified breaks, FLDA shows up.
>
> Thank you,
>
> Eric Kempter

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---