IMPORTANT ANNOUNCEMENT

These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#30270 - 08/17/09 10:59 AM pp design, db emulation generating several pages
ojedagabo Offline
Junior Member

Registered: 04/07/06
Posts: 5
Hi. I'm working in an invoice application. The input data is data base (or could be csv).
For each line of details in the output, then data has one record. That is, if the invoice for a customer has 10 lines of details, the input data has 10 records for that customer.
The output area of details is able to print until 8 details.
The question is, how to produce several pages for one customer, for them that have more than 8 details?. For example, if the data has 10 lines for one client, the output should generate two pages for him. If 24 lines, then 3 pages should be generated

Top
#30271 - 08/17/09 11:19 AM Re: pp design, db emulation generating several pages
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4956
Loc: Objectif Lune Montreal
ojedagabo,

You can try PlanetPress' repetition feature. Load your data file, and try to have all lines for one customer on one single data page. Do not use the CSV emulation. In this case, a database will be easier to work with. Database emulation should create a data page every times a value changes, such as the customer's ID, so that you get one page per customers.

After that, make a couple data selections for the fields of the first record, then group them. In the group's properties, go to Repeat, choose Line Repeat, 1 to 0(0 means all records). This will repeat the data selections for every of the customer's items. In the "Iteration Condition", you can put:
Code:
=&iterationcount = 8
This will create a new page every 8 lines.

Hope this helps.

Regards,
Rapha

Top
#30272 - 08/18/09 05:37 PM Re: pp design, db emulation generating several pages
ojedagabo Offline
Junior Member

Registered: 04/07/06
Posts: 5
I probed all your suggestions, but there are more problems.
Whatever be the number of details, the output is generating one page for each customer.
Additionally, all the detail lines are not visible.
I probed with the instruction:

Top
#30273 - 08/19/09 01:22 PM Re: pp design, db emulation generating several pages
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4956
Loc: Objectif Lune Montreal
ojedagabo,

I've tried a setup similar to yours, with a database with several records, and used "&iterationcount = 8", and that worked for me.

What do you have on a single datapage? This code assumes that all datapages are a different customer, with a variable number of items for each. In that case, the overflow should work.

Regards,
Rapha

Top
#30274 - 08/20/09 04:01 PM Re: pp design, db emulation generating several pages
ojedagabo Offline
Junior Member

Registered: 04/07/06
Posts: 5
The data file has the structure that you described. Please, could you send the probed file that you used? I'll compare it whit mine. Thanks.

Top
#30275 - 08/27/09 01:19 PM Re: pp design, db emulation generating several pages
Anonymous
Unregistered


Hi ojedagabo,

Try putting the condition in the "condition to exit and overflow" instead of "iteration condition". I am confident this will solve your problem.

Please let us know if you still need assistance.

Regards,

Olivier

Top