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

[Former Member]

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

[IngoH]

Hi Artur,

how did you configure it in the BEx Analyzer ?

To me it looks like more an item you want to make sure is being done on the BI query layer.

CR will ask for "non empty" rows from the cube when you include a measure

Ingo

[Former Member]

Hello Ingo,

how did you configure it in the BEx Analyzer ?

there is an radio button in display-options for an element in rows in the Query Designer for displaying for example companies from master data causing that not only booked values will be displayed in Analyzer but also "null"-values. But Crystal Reports seems not to understand this option.

CR will ask for "non empty" rows from the cube when you include a measure

What does it mean?

Thanks,

Artur

Edited by: Artur Witzke on Jan 29, 2009 10:13 AM

[IngoH]

Hi Artur,

when you build a report in CR it will ask in the MDX statement for NON EMPTY rows.

Ingo

[Former Member]

Hi Ingo,

does it happen automatically in the backend or is there any option in CR? How can I display NULL-values?

Thanks,

Artur

Edited by: Artur Witzke on Jan 29, 2009 6:22 PM

[IngoH]

Hi,

it happens automatically

Ingo

[Former Member]

Thanks Ingo. So it means that there is no easy way to display empty rows in CR. What about creating a dummy measure that would have values for every company, than build a report using this measure and cover it with a white textfield? That should work, shouldn't it? What would you suggest?

Edited by: Artur Witzke on Jan 29, 2009 11:26 PM