yeowza
Posts: 16
|
| Posted: 03/11/2008, 12:24 AM |
|
I'm hoping that someone can help lead me in the right direction. I am attempting to print invoices from a system I created with CCS 4. I need to print each invoice on a different page so basically when the order number changes I want to force it to the next page. I can't find an option in the report builder to accomplish this. I also tried the gallery builder but that didn't work either.
Has anyone done anything similar? Any help or ideas would be greatly appreciated.
|
 |
 |
JimmyCrackedCorn
Posts: 583
|
| Posted: 03/11/2008, 1:59 AM |
|
Would these help?
http://forums.yessoftware.com/posts.php?post_id=88156
http://forums.yessoftware.com/posts.php?post_id=88180
_________________
Walter Kempees...you are dearly missed. |
|
|
|
yeowza
Posts: 16
|
| Posted: 03/11/2008, 11:14 AM |
|
Thanks for the reply Jimmy!
Here's how I got it to work for anyone interested.
I used the report builder and created a search for the report. I included "rows per page" option. I modified the value to include 1. Now I make this hidden and set the default to 1. That problem solved. Then for the invoice. I could not join all my tables together otherwise it return the invoice detail for the products ordered. Instead I just created the report on my order table which will return a single row for each order. Next I just added some labels in the report for the order detail. I added code in the before show events on these labels. In the code I queried the database for the product information. I made the labels type HTML so that I could format the output.
The page breaking is handled automatically since I specified 1 row per page so each invoice will print correctly.
I hope that my explanation was clear enough.
|
|
|
|
DonP
|
| Posted: 03/11/2008, 5:43 PM |
|
There's also a method in Style Sheets for specifying page length but I
don't think it is cross-browser compatible. Your way seems to be a good
one. If your invoice has a template of a specified size and design that
cannot grow in length when items are added, any number of items in the
invoice (within reason) could be made to fit a particular area of a
given size.
yeowza wrote:
> I'm hoping that someone can help lead me in the right direction. I am
> attempting to print invoices from a system I created with CCS 4. I need to
> print each invoice on a different page so basically when the order number
> changes I want to force it to the next page. I can't find an option in the
> report builder to accomplish this. I also tried the gallery builder but that
> didn't work either.
>
> Has anyone done anything similar? Any help or ideas would be greatly
> appreciated.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
