Skip to Content
0
Former Member
Mar 03, 2009 at 06:37 PM

How to create a report to bring all data from two different Info providers

18 Views

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