Hi all,
in order to format the background-color of a cell of a cross-tab I used this formula (If CurrentRowIndex Mod 2 = 0 Then Color(223,235,254) Else crNoColor). The report work properly when i run it in crystal report but when i run it in eclipse (with the JRC, which is included in Crystal Reports for Eclipse plug-in version 1.0.4.v1094) there is this exception:
Formula error: recompile formulas failed
com.crystaldecisions.reports.formulas.FormulaException: Exception in formula '{@backColour}' a 'CurrentRowIndex':
Is excpeted a number, an amount in currency, a boolean value, a date or a string.
at com.crystaldecisions.reports.formulas.ab.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ab.do(Unknown Source)
at com.crystaldecisions.reports.formulas.m.a(Unknown Source)
at com.crystaldecisions.reports.formulas.m.P(Unknown Source)
at com.crystaldecisions.reports.formulas.m.m(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.f(Unknown Source)
at com.crystaldecisions.reports.formulas.ag$14.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.o(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.p(Unknown Source)
at com.crystaldecisions.reports.formulas.ag$13.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.s(Unknown Source)
at com.crystaldecisions.reports.formulas.ag$12.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.h(Unknown Source)
at com.crystaldecisions.reports.formulas.ag$11.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.c(Unknown Source)
at com.crystaldecisions.reports.formulas.ag$10.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.l(Unknown Source)
at com.crystaldecisions.reports.formulas.ag$9.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.i(Unknown Source)
at com.crystaldecisions.reports.formulas.ag$8.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.n(Unknown Source)
at com.crystaldecisions.reports.formulas.ag$7.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.t(Unknown Source)
at com.crystaldecisions.reports.formulas.ag$6.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.d(Unknown Source)
at com.crystaldecisions.reports.formulas.ag$5.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.u(Unknown Source)
at com.crystaldecisions.reports.formulas.ag$4.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.b(Unknown Source)
at com.crystaldecisions.reports.formulas.ag$3.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.q(Unknown Source)
at com.crystaldecisions.reports.formulas.ag$2.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.k(Unknown Source)
at com.crystaldecisions.reports.formulas.ag$1.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.a(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.g(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.j(Unknown Source)
at com.crystaldecisions.reports.formulas.m.R(Unknown Source)
at com.crystaldecisions.reports.formulas.m.do(Unknown Source)
at com.crystaldecisions.reports.formulas.m.void(Unknown Source)
at com.crystaldecisions.reports.formulas.ag.a(Unknown Source)
at com.crystaldecisions.reports.formulas.am.a(Unknown Source)
at com.crystaldecisions.reports.formulas.FormulaInfo.do(Unknown Source)
at com.crystaldecisions.reports.formulas.FormulaService.compile(Unknown Source)
at com.crystaldecisions.reports.reportdefinition.fw.compile(Unknown Source)
at com.crystaldecisions.reports.reportdefinition.df.compile(Unknown Source)
at com.crystaldecisions.reports.reportdefinition.eq.else(Unknown Source)
at com.crystaldecisions.reports.reportdefinition.eq.else(Unknown Source)
at com.crystaldecisions.reports.reportdefinition.eq.else(Unknown Source)
at com.crystaldecisions.reports.dataengine.m.if(Unknown Source)
at com.crystaldecisions.reports.dataengine.m.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.m.a(Unknown Source)
at com.crystaldecisions.reports.dataengine.bk.a(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.<init>(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.if(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.e.l.<init>(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.e.p.<init>(Unknown Source)
at com.crystaldecisions.reports.formatter.formatter.e.p.a(Unknown Source)
at com.crystaldecisions.reports.formatter.a.c.a(Unknown Source)
at com.crystaldecisions.reports.formatter.a.c.if(Unknown Source)
at com.crystaldecisions.reports.formatter.a.c.a(Unknown Source)
at com.businessobjects.reports.sdk.b.b.int(Unknown Source)
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.x.a(Unknown Source)
at com.crystaldecisions.proxy.remoteagent.q.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.dd.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.ReportSource.export(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.export(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.NonDCPAdvancedReportSource.export(Unknown Source)
at com.crystaldecisions.reports.reportengineinterface.JPEReportSource.export(Unknown Source)
at com.crystaldecisions.report.web.event.br.a(Unknown Source)
at com.crystaldecisions.report.web.event.w.a(Unknown Source)
at com.crystaldecisions.report.web.event.b7.broadcast(Unknown Source)
at com.crystaldecisions.report.web.event.av.a(Unknown Source)
at com.crystaldecisions.report.web.WorkflowController.do(Unknown Source)
at com.crystaldecisions.report.web.WorkflowController.doLifecycle(Unknown Source)
at com.crystaldecisions.report.web.ServerControl.a(Unknown Source)
at com.crystaldecisions.report.web.viewer.ReportExportControl.a(Unknown Source)
at com.crystaldecisions.report.web.ServerControl.getHtmlContent(Unknown Source)
Do you know how to solve this problem or if there is some another solution?
Thanks