| group above report on HIERARCHY data [message #213263] |
Wed, 10 January 2007 01:53  |
annu-agi1
Messages: 17
Registered: August 2006
Location: Pakistan
|
Junior Member |
|
|
data like this
002 PACKING MATERIAL Category 0 0 0 0
002001 CORRUGATED CARTONS Category 0 0 0 0
002001001 CARTON # 6 Item 0 0 0 0
002001002 CARTON # 3 Item 0 0 0 0
002002 10 LITERS PACKING ITEM Category 0 0 0 0
002002001 LIDS 10 LTR Item 1350 0 0 1350
002002002 BOX 10 LTR Item 1150 0 0 1150
002002003 LID 10 LTR(GREEN) Item 100 0 0 100
can any body tell me how can i make group above report on the bases of tree type data .. group above fires on the condition if item = category and detail portion is items
[EDIT] Next time use [code] tags instead of [size] ones; Size doesn't improve readability, but [code] does.
[Updated on: Wed, 10 January 2007 02:47] by Moderator Report message to a moderator |
|
|
|
| Re: group above report on HIERARCHY data [message #213277 is a reply to message #213263] |
Wed, 10 January 2007 02:53  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
When you create a query, in a Data Model all columns are displayed in a square (representing a group) below this query. To create another group, click on a desired column and drag it out of existing group and put it on a line which connects a query and the existing group.
It will create another square (a group); you can drag another columns into it (if necessary).
Following the same procedure, create as many groups as you wish.
Delete all that exists in the Paper Layout and use Report Wizard which will "draw" a new structure for you. Just make it look better after Wizard does its job.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
