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.

Comments

  • edited 4:26PM
    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
  • edited 4:26PM
    If you are getting your data from SQL,
    you can use something like this
    (with oracle)

    Select *
    From MYTABLE
    where ROWNUM <= 20
  • edited 4:26PM
    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
  • edited 4:26PM
    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
  • edited 4:26PM
    I think if you use TfrDBDataset
    you can Set RangeEnd value reCount
    Set RangeEndCount = 20
    but RecordCount must be >= 20

    I hope it can help you!

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.