Skip to Content

Calculated Member on Cross Tab appears in designer Preview but not in scheduled report output

Oct 27, 2017 at 04:26 AM


avatar image

I have a report that has a cross tab that incorporates a calculated member column (it's a long story as to why I need it - short version is that some of the totals use a different summary type to the detail columns e.g. detail = sum, total = average).

Everything works perfectly in the preview in Crystal Reports Designer 2011 ( When I upload it to Enterprise/BIP/Infoview/Whatever it's called these days and view the report, the calculated member column does not appear. This is true no matter what format I output it as using a schedule or even if I attempt to view it.

I've tried a bunch of things but am out of ideas...

Server is BO Edge 4.0 sp10

I have followed instructions from this:

Also this:

And this:

Insertion formula is currently (I have tried changing it but nothing seems to work):

GetColumnGroupIndexOf(CurrentColumnIndex) = 0

Insert evaluation radio button is currently set to Before (have tried changing it to After).

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers