Select number of report lines

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
westover
Posts: 1
Joined: Wed Mar 14, 2018 7:13 pm

Select number of report lines

Post by westover » Wed Mar 14, 2018 7:42 pm

How can I limit a report/extract to a selected but changeable number of lines
e.g. The top ten/twenty customers only

Currently the only way I can see is to do something with current page but not very satisfactory

TIA
Peter

User avatar
cstrasser
Posts: 155
Joined: Tue Oct 10, 2017 12:44 pm

Re: Select number of report lines

Post by cstrasser » Wed Mar 21, 2018 10:43 pm

The easiest way I can think of doing this is to create three fields:

1. A ParameteRR field which holds the number of records you want to create the limit for
2. A running total field of the value you want to restrict (count)
3. A boolean / logical calculated field comparing the ParameteRR with the total and returning True if it's less and False if more

Then on the line in question, create a line-logic property and set it to print if True. When you run the report or export it, you should only get the lines that correspond.
Chris Strasser
Liveware Publishing, Inc.
Work bigger.

Post Reply