Data Disappears on Export or Preview

other Xcelsius - Crystal Dashboard Design
1

I’ve been using CX for a couple years now and this is the first time something like this has ever happened to me.

I have about nine value components that are tied to cells in my spreadsheet with simple calculations (AVERAGE, SUM, MAX). When I am in design mode everything shows up fine but when I preview or export those values (but not their associated labels) go blank.

As if that’s not weird enough, I added another value field to the XLF that links to a cell on the spreadsheet that simply has “=B15” which references one of the source cells that disappears. When I do that, the new value field displays but suddenly, so does the other one that was previously disappearing.

I’m using CX 4.5.

Source file: http://www.11oh1.net/fc/Claims.xlf

P.S. I know there’s a topic similar to this one nearby but I’m not using any crazy formulas like the other poster. Just standard stuff.

mattkrets (BOB member since 2009-01-27)

2

Hi

I understand your problem but not able to download the Xlf file. Can you send it again.

mandavasriharibabu :india: (BOB member since 2009-01-08)

3

Hi, mattkrets and mandavasriharibabu,

I’m still having the same issue with “normal formulas”…
I hope we’ll find a solution!

Ludovic

PS: Have you tried to install a visual basic hotfix recommended in this topic? “An unhandled exception win32 occurred in Xcelsius.exe”
It didn’t work for me but maybe will be ok for you.

luron01 :fr: (BOB member since 2009-01-26)

4

Hi mattkrets,

Maybe you can try what is recommended in this forum https://www.sdn.sap.com/irj/scn/thread?messageID=6757460#6757460
It didn’t work for me, but maybe this will help you.

Ludovic

luron01 :fr: (BOB member since 2009-01-26)