Crystal Reports display problem, if measures don't have values

35 Views

Hi All,

I have a problem with Crystal Reports. We are using a SAP query as a datasource without any joins. There is for example a datafield called "Company" and associated measure called "Sales". So if I only display the company, I have 20 rows of data. As soon as I want to display the measure, the number of datarows decreases to 12, couse the other 8 companies has no sales value. But I want to see this values to be shown as "0" or "-". How does it work? Couse if I display another measure, that has value for every company, I have the desired constelation and "sales" are displayed as "0". In BEx Analyzer I have also the required constelation. That means that the configuration must be done in CR and not in BEx Query Designer. Is it right?

Thanks,

Artur

Edited by: Artur Witzke on Jan 28, 2009 5:40 PM