Hi All,
I have a peculier problem while creating a report. I have two custom info providers one DSO and another Cube. There are only two common fields between these two Info providers . I need to create a report such that the report displays all the values from DSO but user can have the selection option on one of the fields in the Cube.
Here is an example
DSO Contents:
DocNum- DocItem- DocText- Amount- Quantity
10000---- 10---- ABC---- 100---- 10
10001---- 20---- DSN---- 200---- 10
10005---- 20---- DSN---- 200---- 10
Z1003---- 10---- CAN---- 500---- 1
Cube Contents
DocNum- DocItem- Date----- InvoiceAmt
10000---- 10---- 1/10/2009---- 50
10001---- 20---- 2/20/2009---- 100
10005---- 20---- 2/25/2009---- 100
The report needs to be displayed as shown below when the user selects value for date from 1/10/2009 to 2/20/2009
DocNum- DocItem- DocText- Amount- Quantity
10000---- 10---- ABC---- 100---- 10
10001---- 20---- DSN---- 200---- 10
I hope this was clear for you to understand. I would really appricate if any one can answers about how to resolve this problem. I cannot add the date filed to DSO and I also have Doc Num and Item as the user selection fields in the report.
Thank you all in advance and i would really appreciate for your suggestions.
Regards
Chinna
Edited by: chinna2479 on Mar 3, 2009 7:38 PM
Edited by: chinna2479 on Mar 3, 2009 7:39 PM