To create Report with Header Detail Style

[krist]

Hi again,
I want to create RPT using 2 table, OrderHeader and OrderDetail, the report looks like this :

----Order_Header---------- ----Order_Detail--------------
OrderId Date Customer ProductId Qty Price Amount
--------------------------------------------------------------
0000001 dd/mm/yy abcde productA 3 10 30
productB 2 11 22
productC 3 10 30

I don't want to use subreport, what is the other way to do this ??

Thanks for help,
Krist

 

[MalcolmW]

Link your two tables Order Header and Order Detail, probably with OrderID (though I don't know your complete table structure).
Group by OrderID. Assuming that this is your innermost group, then:
Format the OrderID group header section to overlay following sections.
Put the Order Header info as shown in your example.
Put the Order Detail info in the detail section
This will produce output formatted as you described. Malcolm Wynden
Authorized Crystal Engineer

http://www.wynden.net

malcolm@wynden.net

 

[PrakashKC]

Hi,
First Link the two tables...

then Select the Fields, OrderId, Date, Customer, ProductId, Qty, Price, Amount, etc...

Now Sort the details first via OrderId, then Date and then Customer...

Then In the Format Section of these three fields just have SUPPRESS IF DUPLICATED checked and you will get the desired result...