| Two layouts in one Report and one query. [message #157665] |
Fri, 03 February 2006 13:04  |
satyauvce
Messages: 6
Registered: August 2005
|
Junior Member |
|
|
Hi all
I have a requirement in which need to display information in two ways.
This is a sales report.
First format is : the customer wants all sales of one item type in each state between selected dates.
There are two item types Steel and Wood(for example)
E.g
State Item_Type Qty
State 1 Steel 10 Ton
State 1 Wood 5 Ton
State 2 Steel 20 Ton
State 3 Wood 8 Ton
--------------------------------------------------------
Below the Above data the second format has to be printed
in the same report.
Second FOrmat is : the sales of each item_type
Steel 30 Tons
Wood 13 Tons
--------------------------------------------------------
Now I can write two Queries and get the required output,but as it will take a lot of time (almost double) how to get the desired result using single query
Thanks in advance.
Satya.
|
|
|
|
|
|
| Re: Two layouts in one Report and one query. [message #157748 is a reply to message #157747] |
Sun, 05 February 2006 05:43  |
satyauvce
Messages: 6
Registered: August 2005
|
Junior Member |
|
|
Hi Thanks for the reply,
Can you please elobrate on how to use summary columns.
I have two group onw refering to state and below that item type and quantity.
Now can easily get statewise sum because it is on a higher level.
--------------------------------
Group ::State Group
Fields::State
Group ::Item_type
Fields::a)Item_type
b)Qty
--------------------------------
I made another repeating group which refers the item_type "Group"(Below State).
But it is showing up all the records.In this case how to sum.
Thanks and regards.
Satya.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
