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
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.