Urgent Diplay all types

[naveen_hadagali]

Hi All,

I have a very urgent  requirement where i need to display product type and the corresponding sales total for particular customer and for selected date.
It will be like this
Type       Total
A            XXXX

B             XXXX

C             XXXX

D               XXXX

This can be done but if for a particular month the customer has no transaction for type c and d then the report shows only for type a and b

Type        Total

A            XXXX

B             XXXX


But i need it to be dipalyed for all the types irrespective of whether he had transaction for that type or not

it should be like this

Type    Total

A          XXXX

B          XXXX

C           00

D           00

Any suggestions of how to get this is highly appreciated ..... Thanks in advance

regards
Naveen

[MFGF]

Hi,

Assuming this is relational data, it will need to be modelled to use an outer join (optional relationship) between your product types and sales.  The ideal place for this is in Framework Manager.  Alternatively, you will need to create two queries in your report - one to collect the product types, one to collect the product type sales, then join the queries using 0..n cardinality at the sales end and bring the results through into a third query which provides the data for your list.

Regards,

MF.