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
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.

westover
Posts: 2
Joined: Wed Mar 14, 2018 7:13 pm

Re: Select number of report lines

Post by westover » Fri May 11, 2018 11:33 am

Thanks Chris

By the time my original message had been approved ( about 5 days) I'd worked it out !

I did a running count of the group and a print line test that only printed while the count was less than 20

Regards
Peter

Post Reply