How to print report only 20 line.

Comments

• Roth_Soft

  March 2004 edited 9:28AM

  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

  March 2004 edited 9:28AM

  If you are getting your data from SQL,
  you can use something like this
  (with oracle)
  
  Select *
  From MYTABLE
  where ROWNUM <= 20
  
• basswar

  March 2004 edited 9:28AM

  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

  March 2004 edited 9:28AM

  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

  March 2004 edited 9:28AM

  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!