WEBI Report with 2 Dates

[skkz]

Hi,

I have develop a report in WEBi, The report looks like this

PCODE P_QTY PDATE RQTY RDATE
1111 500 2/2/1996 1200 12/11/98
1111 500 2/2/1996 1200 09/08/98
1111 500 2/2/1996 1200 05/11/98

But the user said he don't want to see the repeated data in Prod qty and Prod date column. they want the report in below format

PCODE P_Qty PDATE RQTY RDate
1111 500 2/2/1996
1111 1200 12/11/98
1111 1200 09/08/98
1111 1200 05/11/98

I tried to do this by creating 2 queries. 1 Query I added Product_COde, Prod_Qty and Prod_Date and 2nd Query I added Product_code, Recp_Qty and Recp_Date. and I merged the dimension, I also merged the date dimension

Then I got the below format

PCODE PQty RQty Date
1111 500 2/2/1996
1111 1200 12/11/98
1111 1200 09/08/98
1111 1200 05/11/98
2222
2222 600 1420 07/11/98

But I am getting a row between each Product code with empty data in other columns.

Please help

 

[lbass]

You have already been given a solution in
thread149-1500097. You should stick with that thread and if you are having trouble implementing the solution, explain why.

-LB