Skip to Content
0
Former Member
May 13, 2010 at 02:07 AM

Issues with Bex query structures and Crystal Reports/Webi

26 Views

Hi experts,

I'm having an issue with Bex Query structures and nulls. I've built a Crystal Report against a Bex query that uses a Bex Query structure. The structure looks like the following

Budget $

Budget %

Actual $

Actual %

Budget YTD

etc

if I drag the structure into the Crystal Report detail section with a key figure it displays like this

Budget $ <null>

Budget % <null>

Actual $ 300

Actual % 85

Budget YTD 250

the null values are displayed (and this is what is required). However if I filter using a Record selection or group on a profit centre then the nulls along with the associated structure component are not displayed.

Actual $ 300

Actual % 85

Budget YTD 250

Webi is also behaving similarly. Can anyone explain why the above is happening and suggest a solution either on the Bex side of things or on the Crystal Reports side of things? I'm confused as to why nulls are displayed in the first example and not the second.

Business Objects Edge 3.1 SP2

SAP Int Kit SP2

OS: Linux

BW 701 Level 6

Crystal Reports 2008 V1

Thanks

Keith