I have created a query and restricting it with select list of values for a particular characteristic. In a row, I have that characteristic and lets say, have one key figure. I want entire list of restricted characteristic values along with the keyfigure in the report. But the problem is if that restricted characteristic value is not found in Multiprovider, that entry will not be displayed in a report as it has null value. However, I want to display that restricted characteristic value with 0 as its keyfigure value.
Can anybody suggest what can be done ?
Thanks & Regards,