Source language: Translate to:

Multiple Invoice Report

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Multiple Invoice Report

Postby stu » Tue Jan 20, 2015 11:53 am

Hi!

Does anyone have any experience trying to generate a long batch of invoices all at once?

The idea is generate 200+ invoices all from a single report file. Similar in concept to the invoice report from the OrderEntry sample database but instead of generating for a single user you grab a whole lot and replicate the report.

I guess problem is that you need two table to do that, one is the 'Customers' table (all the peeps that'll get the invoice) and the other is a cross join between:

CUSTOMERS --- > ORDER ----> PRODUCTS

This is the query I'm using at the moment:

Syntax: [ Download ] [ Hide ]
Using SQL Syntax Highlighting
SELECT
Parsed in 0.005 seconds, using GeSHi 1.0.8.10


So one invoice per customer and several products per order. So far I've made all sort of messy combinations that left me with very few chances... (?)

This picture can graphic pretty good what I'm looking for:

Image

So as you can see its a single file with many invoices on, the red arrow points where the 'Customer' part its displayed and the blue arrow points where the 'Products' are displayed.

The link between both tables its 'User Account' so basically (according to my concept) the Invoice detail part will display only the products that belong to the user account.

Hopefully I'm making myself clear...

Any ideas my dear friends!
Last edited by stu on Wed Feb 24, 2016 11:57 am, edited 1 time in total.
User avatar
stu
 
Posts: 320
Joined: Wed Aug 07, 2013 11:37 am

Re: Multiple Invoice Report

Postby stu » Fri Jan 23, 2015 6:28 am

Ok, so It took me a while but I finally got the result I was looking for, I made a new view and instead of trying to create a report from different tables.

Here's what the final view looks like:

Syntax: [ Download ] [ Hide ]
Using SQL Syntax Highlighting
SELECT
 
Parsed in 0.004 seconds, using GeSHi 1.0.8.10


Then I created a report with PAGE BREAK at the group Footer and game the the exact result I was looking for.

=)
Last edited by stu on Wed Feb 24, 2016 11:56 am, edited 2 times in total.
User avatar
stu
 
Posts: 320
Joined: Wed Aug 07, 2013 11:37 am

Re: Multiple Invoice Report

Postby Neosoft Support » Fri Jan 23, 2015 12:01 pm

That was a hard one. I'm glad you figured it out!
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5602
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest