How to add 3 reports?

  • Thread starter Thread starter zaskodnik
  • Start date Start date
Z

zaskodnik

Hi,

How can I add three separate reports into one?
I have one report calculating amount of ordered pieces, another repor
for shipped and another for forecasted. All is by territory.
I need to make ONE report that will look like this:
Shipped Ordered Forecasted Total
Japan 20 5 2 27
Korea 10 10 1 21
Europe 5 1 2 8
Total 35 16 5 56

Each report that I have has only this:
Shipped
Japan 20
Korea 10
Europe 5

Does anyone know? I really appreciate your help. Thank you!

Petr
 
zaskodnik said:
How can I add three separate reports into one?
I have one report calculating amount of ordered pieces, another report
for shipped and another for forecasted. All is by territory.
I need to make ONE report that will look like this:
Shipped Ordered Forecasted Total
Japan 20 5 2 27
Korea 10 10 1 21
Europe 5 1 2 8
Total 35 16 5 56

Each report that I have has only this:
Shipped
Japan 20
Korea 10
Europe 5
Click to expand...


The secret to creating reports is to devise a query that
organizes the data into a relatively straightforward list of
records.

The secret to creating a query is to start from your data
tables. Assuming the tables are reasonably well normalized,
this is usually a matter of Joining the tables on their PK -
FK relationships.

If that's too vague to get you going, post back with an
explanation of the relevant tables and their fields.
 
Back
Top