How to print report only 20 line.
I select data and get more than 20 records. how i can set Tfrband to show only 20 records.
and the rest records, I want to sumarize to 1 record to be in the same Tfrband or another Tfrband.
Thanks.
and the rest records, I want to sumarize to 1 record to be in the same Tfrband or another Tfrband.
Thanks.
Comments
I hope this helps.
Cheers
Stefan
you can use something like this
(with oracle)
Select *
From MYTABLE
where ROWNUM <= 20
The report-level solution is a little bit complicated. Write here your mail and I will send you the working frf file.
Regards:Alex
Don't provide your email, I uploaded the frf to the Yahoo groups file section. The link is:
http://f3.grp.yahoofs.com/v1/AEBhQN8MsplOm...c4PQ/only20.frf
Regards:Alex
you can Set RangeEnd value reCount
Set RangeEndCount = 20but RecordCount must be >= 20
I hope it can help you!