Home » Developer & Programmer » Reports & Discoverer » group above report on HIERARCHY data
group above report on HIERARCHY data [message #213263] Wed, 10 January 2007 01:53 Go to next message
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 Go to previous message
Littlefoot
Messages: 20900
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.
Previous Topic: Parse a string and convert the text
Next Topic: report
Goto Forum:
  


Current Time: Thu Dec 08 04:22:32 CST 2016

Total time taken to generate the page: 0.13805 seconds