Creating a "Print All" function from a recordset?

Is it possible to create a "Print All" function using records in a recordset, for example a list of orders and to then mark them as having been printed?

At the moment we view these in a recordset list and then click a button to view them individually on a dynamic page, which is a nice invoice layout, however this means that the client has to click print for every individual order - which is ruining their life apparently. :)

This isn't a big deal on slow sales days but they can receive up to 500 orders per day during busy times and having to individually print each invoice, albeit at least it's methodical (view on screen, pack, print invoice, post), isn't what they want.

Appreciate any advice offered. Thank you.
NJ

You should be able to put the details page into a repeat region and use the results recordset so that all the orders are displayed on one page and can be printed. Then you could add a print style sheet to make sure the individual orders are printed on their own page.

Originally Said By: Ray Borduin

  Then you could add a print style sheet to make sure the individual orders are printed on their own page.  

How does a stylesheet set up page breaks? What is that functionality called and I'll run a Google for some solutions?
Thanks Ray.

NJ

You can read about it here:
http://www.w3schools.com/cssref/pr_print_pageba.asp

Thank you.

In terms of marking orders as having been printed...that would involve saving to database I would imagine. Do you have any tutorials on saving multiple records to database, which is probably what I'll need. Maybe this is a function of DataAssist?

Much appreciated.
NJ

You could probably just use the regular update record server behavior and then add it to the repeated region so that it does it for each row as it is repeated. Then just set the id of the updated record to the id from the repeated recordset.

Originally Said By: Ray Borduin

  You should be able to put the details page into a repeat region and use the results recordset so that all the orders are displayed on one page and can be printed. Then you could add a print style sheet to make sure the individual orders are printed on their own page.  

Problem with that is the orders and orderdetails tables are two seperate tables and one"invoice" page contains data from both, including a repeat region for the line items. I'm not clear how I put all that into another repeat region?

You can nest a recordset inside the repeat region to pull records from another table.

So...

<Recordset All Orders Repeat Region>
Recordset Order Table Info

<Recordset OrderDetails Repeat Region>
Recordset OrderDetails Table Info
</Recordset OrderDetailsRepeat Region>

</Recordset All Orders Repeat Region>

Is that something new for MySQLi? I always remember having to download some extension in the past for nested repeat regions.

It may not allow you to apply the repeat region inside another, but you can apply it below and copy/paste it into it and it should function properly.