Skip to Content
author's profile photo Former Member
Former Member

Cross-Tab. Calculated Members not visible on Crystal Reports XI Runtime

Hello,

I have a big problem. I have developed a sale report on which I have inserted crosstabs and added calculated members on them to compute the percentage growth.

Development was made in SAP CrystalReports 2011 [14.0.4.738 RTM] and there when i use Preview mode everything looks good. But when i transfer my report to production application and start it from there the calculated members column doesn't appear.

One of my cross tabs look like this:

2013 2014 % growth January 100 120 20 February 100 120 20 Total 200 240 -

When I test it in companys ERP the '% growth' table is missing. The runtime insalled on our clients machines is CR XI Runtime - I think it should work there? Am I wrong?

My functions for computed members:

1. Insertion formula:

GetColumnGroupIndexOf(CurrentColumnIndex) = 1

and GridRowColumnValue("table1.column1") = {"table2.column2}

2. Calculation formula:

if(gridvalueat(currentrowindex, CurrentColumnIndex-2, CurrentSummaryIndex) = 0) and (gridvalueat(currentrowindex, CurrentColumnIndex-1, CurrentSummaryIndex) = 0)

then 0

else if(gridvalueat(currentrowindex, CurrentColumnIndex-2, CurrentSummaryIndex) = 0)

then 100

else

(gridvalueat(currentrowindex, CurrentColumnIndex-1, CurrentSummaryIndex)-gridvalueat(currentrowindex, CurrentColumnIndex-2, CurrentSummaryIndex))/gridvalueat(currentrowindex, CurrentColumnIndex-2, CurrentSummaryIndex)*100

Any help will be appreciated.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Dec 10, 2014 at 12:13 PM

    Hi Piotr,

    CR XI didn't support calculated members. The feature was introduced in CR 2008.

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you i've checked the compatibility list for CrystalReports and you are right.

      Maybe you know some workaround for that?

      If there isn't such thing.. A lot of work ahead of me then...

      Thank you one more time

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.