Crystal Report 2011 does not display when keyfigures are zero

[Former Member]

I am using Crystal report 2011 with BEX Queries as Data Source. I am not able to see some of the characteristics values when keyfigures are zero or null. In BEX query there is a costCenter Characterstic, few costcenter characteristics values are zero for some months but BEX Query is designed to show as spaces even if the keyfigures are zero for those costcenters. When I am using the same Bex Query with Crystal report 2011 all the costcenters with keyfigures as zero are not showing up on the report. Can anybody suggest how I can show the characterstics values even if all the keyfigures are zero. (I have not selected any kind of suppression in section expert in crystal report), (In Bex Query CostCenter- Properties-Advanced----Access Type for Result values are set to Master Data)

[Former Member]

Ok...I tried all the above suggestion but it still did not solve my issue.

There is a feature ShowEmptyRows in CR 2011. When I selected this I am able to see the all the Characterstics value of CostCenter but when I add one more charactersitc(e.g CostElement) to the report it crashes.

Looks like it is doing a cartesian product when I add multiple charactersitcs to the report which might be creating huge number of empty rows and causing report to crash. I dont know how I can control the large number of empty rows.

Edited by: Arazebanq on Jan 9, 2012 5:20 PM

[former_member11696]

Have you installed all of the Connectors on the SAP Server from which ever service Pack you are on?

Have you updated CR 2011 to SP 2?

Don

[Former Member]

Have you tried going to File, Report Options, and checking the options to Convert Database NULL Values to Default and Convert Other NULL Values to Default? This has worked for me in the past.

[former_member11696]

As well as Keely's suggestion also search in here for "isNull" and you will find more info. When CR evaluates a record selection formula and comes across a null and you don't test for it CR stops processing the formula.

Don

[abhilash_kumar]

Hi,

Have you made sure the correct Transport files have been loaded on the SAP system? Since you're using CR 2011, you need to make sure the Transports that come with this version of CR are present on the SAP system.

Could you see if the workaround mentioned in SAP Note: 1391673 works for you?

Here's a snippet of the SAP Note:

SAP Development team of BW BEX MDX Interface suggest the following implementation:

Since Crystal Reports is not correctly interpreting the character used to represent NULL values (by default the value: X) please use the Customizing transaction: RSCUSTV4 to change the sent value.

Please note, this is a Global setting, and will also modify the behaviour in BEx application.

WORKAROUND: Create a formula field based on the selection that always returns a number - converting null to 0.

Create a formula in BEx for the KF.

Edit the Selection

Edit the formula to behave like:

COUNT ('KF') * 'KF' + 0

('RKF' + 0) * 1

Not generally acceptable since it requires duplicating fields.

Also, business may not accept 0,00 for a NULL result.

Hope this helps!

-Abhilash

[Former Member]

Hi Abhi,

I am also facing similar kind of issue.

Hierarchical report - when key figures are empty  (blank rows) are not coming inside CR2011( version : 14.0.4.738 RTM)

Requirement is too see all the nodes in hierarchy.

Is there any ways to achieve it?   (using alias query is not a option because of usage of "next" function)

Thanks in advance for your reply.

Sree