close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Creating a "Print All" function from a recordset?

Thread began 9/03/2015 11:50 am by Nathon Jones Web Design | Last modified 9/03/2015 5:26 pm by Ray Borduin | 575 views | 9 replies |

Nathon Jones Web Design

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

Nathon Jones Web Design

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

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post

Nathon Jones Web Design

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

Nathon Jones Web Design

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?

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post

Nathon Jones Web Design

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...