on 12-10-2014 12:00 PM
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.
Hi Piotr,
CR XI didn't support calculated members. The feature was introduced in CR 2008.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.