How to print report only 20 line.

cymonx

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.

Roth_Soft

Maybe you can do it with the TfrUserDataSet, where you can set the RangeEnd to reCount. Now you have to define the OnFirst and OnNext event for browsing through your dataset (yourdataset.first / .next).
I hope this helps.

Cheers
Stefan

Nack

If you are getting your data from SQL,
you can use something like this
(with oracle)

Select *
From MYTABLE
where ROWNUM <= 20

basswar

The first is the db-level solution. Many db-engine has a syntax to fetch x rows from the opened cursor and to skip some. See the example above from Oracle. FireBird also has this capability with SELECT FIRST X SKIP Y FROM ....

The report-level solution is a little bit complicated. Write here your mail and I will send you the working frf file.

Regards:Alex

basswar

Hi!

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

sillyboy

I think if you use TfrDBDataset
you can Set RangeEnd value reCount
Set RangeEndCount = 20but RecordCount must be >= 20

I hope it can help you!