Need help ! Urgent on BOXI Report

[skkz]

I have develop a report in BOXI using WEBI. Ther is only 1 univere with 5 table.
The report looks like this :

product Product_Qty Actual_date Receipt_Qty Rec_date
11101 100.00 12/6/05 5465.98 5/07/04
11101 100.00 12/6/05 5758.25 4/04/07
11101 100.00 12/6/05 2525.23 5/12/05

the user want to the data in the report like this :

product Product_Qty Actual_date Receipt_Qty Rec_date
11101 100.00 12/6/05
11101 5465.98 5/07/04
11101 5758.25 4/04/07
11101 2525.23 5/12/05

What should i do to bring the report in above format
I tried using 2 query but did not worked,

please help

 

[Turkbear]

Hi,
One way..
In the CR designer, concatenate the Product,Product_Qty and Actual_date fields into one ( converting to text where needed) and Group on that new field ( formula)[do not show the group name in the header] ..
In the Group header, place the Product,Product_Qty and Actual_date fields ( individually )
Then, in the details for that group, add the product,Receipt_qty and Rec_date fields..





To Paraphrase:"The Help you get is proportional to the Help you give.."