Print a section more than once

[rnd]

SQl Server 2K Crystal 8.5.
Situation: I need to print tickets for order with multiple sections depending on the quantity ordered.
Example: Order 1 (Group 1)
Section (Group 2)
Section 1 - Qty 3
Section 2 - Qty 1
Section 3 - Qty 2 so on.

When it says Qty 1 the ticket should print once for that section (Contents of the tickets are immaterial - just like Name, address etc).
When it says Qty 2 then the ticket should print 2 copies of the tickets for that section.
The same thing goes on depending on the Qty.
Is it possible and how.
Please help.
Thanks in advance.

 

[synapsevampire]

Not readily done within CR 8.5 because of the 254 char limit output.

I'd create another table with:

QTY1
QTY2
QTY2
QTY3
QTY3
QTY3
etc...

Now left join your table to it on the qty field and you'll get the desired qty. Otherwise you might corrct the actual data to have the number of records required.

-k

 

[Ngolem]

Actually it isn't as hard as SV suggested to do this in CR 8.5

Simply create several Subsections in the detail section

Each subsection will have identical fields/formulas positioned for the ticket.

The only trick is to figure out the maximum number of tickets you would deliver....let us say it is 10

then you would create 10 detail subsections of one ticket each.

In the section expert for the "conditional suppress" for each ticket you would put the following formula

for Detail A

WhileprintingRecords;

{table.Qty} < 1;

for Detail B

WhileprintingRecords;

{table.Qty} < 2;

for Detail C

WhileprintingRecords;

{table.Qty} < 3;


... you get the picture ...

Also make sure ON THE DETAIL SUBSECTIONS ONLY that you enable the Keep Together for each one....this will stop a ticket splitting over 2 pages.

That should work well...a bit tedious but add 25 - 50% more ticket &quot;subsections&quot; than you expect as a max and that should handle it...you might want a message to pop-up in the report if that level is exceeded though.

Hope this helps





Jim Broadbent