Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Time range parameter doesn't work in JRC

Hi All,

I have a optional parameter (BusinessHours) with time type in my report. In my selection formula I have a statment like:

If HasValue({?BusineeHours}) Then

// do something

Else

// do something else

The report WORKS fine when running within report designer,but when I run it via web brower (JRC+Tomcat), it gives me an error:

Exception in formula '{@Record Selection}' at 'HasValue': A number, currency amount, boolean, date, time, date-time, or string is expected here.

The exception in tomcat console is:

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Exception in formul

a '{@Record Selection}' at 'HasValue':

A number, currency amount, boolean, date, time, date-time, or string is expected

here.---- Error code:-2147467259 Error code name:failed

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(Unknown Sou

rce)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unkno

wn 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(Unkno

wn Source)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.getPage

(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource

.getPage(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.NonDCPAdvancedReport

Source.getPage(Unknown Source)

at com.crystaldecisions.reports.reportengineinterface.JPEReportSource.ge

tPage(Unknown Source)

at com.crystaldecisions.report.web.event.ac.a(Unknown Source)

at com.crystaldecisions.report.web.event.ac.a(Unknown Source)

at com.crystaldecisions.report.web.event.b2.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(Unknow

n Source)

at com.crystaldecisions.report.web.ServerControl.a(Unknown Source)

at com.crystaldecisions.report.web.ServerControl.processHttpRequest(Unkn

own Source)

at org.apache.jsp.CrystalReportViewer_jsp._jspService(CrystalReportViewe

r_jsp.java:70)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper

.java:210)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2

95)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:247)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:193)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

alve.java:256)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex

t.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav

a:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

alve.java:191)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex

t.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav

a:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:

2416)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j

ava:180)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex

t.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatche

rValve.java:171)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex

t.invokeNext(StandardPipeline.java:641)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j

ava:172)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex

t.invokeNext(StandardPipeline.java:641)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav

a:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal

ve.java:174)

at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex

t.invokeNext(StandardPipeline.java:643)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav

a:480)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:22

3)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java

:601)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce

ssConnection(Http11Protocol.java:392)

at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java

:565)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP

ool.java:619)

at java.lang.Thread.run(Thread.java:534)

Caused by: com.crystaldecisions.reports.formatter.formatter.c: Exception in form

ula '{@Record Selection}' at 'HasValue':

A number, currency amount, boolean, date, time, date-time, or string is expected

here.

at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.<

init>(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.i

f(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.e.l.<init>(Unknown S

ource)

at com.crystaldecisions.reports.formatter.formatter.e.p.<init>(Unknown S

ource)

at com.crystaldecisions.reports.formatter.formatter.e.p.a(Unknown Source

)

at com.businessobjects.reports.sdk.b.b.a(Unknown Source)

at com.businessobjects.reports.sdk.b.b.byte(Unknown Source)

... 54 more

Caused by: com.crystaldecisions.reports.dataengine.be: Exception in formula '{@R

ecord Selection}' at 'HasValue':

A number, currency amount, boolean, date, time, date-time, or string is expected

here.

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)

... 61 more

Caused by: com.crystaldecisions.reports.formulas.FormulaException: Exception in

formula '{@Record Selection}' at 'HasValue':

A number, currency amount, boolean, date, time, date-time, or string is expected

here.

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.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.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 Sour

ce)

at com.crystaldecisions.reports.reportdefinition.df.compile(Unknown Sour

ce)

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)

... 65 more

Caused by:

com.crystaldecisions.reports.formatter.formatter.c: Exception in formula '{@Reco

rd Selection}' at 'HasValue':

A number, currency amount, boolean, date, time, date-time, or string is expected

here.

at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.<

init>(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.bv.i

f(Unknown Source)

at com.crystaldecisions.reports.formatter.formatter.e.l.<init>(Unknown S

ource)

at com.crystaldecisions.reports.formatter.formatter.e.p.<init>(Unknown S

ource)

at com.crystaldecisions.reports.formatter.formatter.e.p.a(Unknown Source

)

at com.businessobjects.reports.sdk.b.b.a(Unknown Source)

at com.businessobjects.reports.sdk.b.b.byte(Unknown Source)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unkno

wn 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(Unkno

wn Source)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.getPage

(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource

.getPage(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.NonDCPAdvancedReport

Source.getPage(Unknown Source)

at com.crystaldecisions.reports.reportengineinterface.JPEReportSource.ge

tPage(Unknown Source)

at com.crystaldecisions.report.web.event.ac.a(Unknown Source)

at com.crystaldecisions.report.web.event.ac.a(Unknown Source)

at com.crystaldecisions.report.web.event.b2.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(Unknow

n Source)

at com.crystaldecisions.report.web.ServerControl.a(Unknown Source)

at com.crystaldecisions.report.web.ServerControl.processHttpRequest(Unkn

own Source)

at org.apache.jsp.CrystalReportViewer_jsp._jspService(CrystalReportViewe

r_jsp.java:70)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper

.java:210)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2

95)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.catalina

Thanks,

Dennis

replied

Current versions of the Java Reporting Component (JRC) do not support new Crystal Reports 2008 features like optional parameters.

The next version of the JRC - Crystal Reports for Eclipse version 2 - will support Crystal Reports 2008 features.

Sincerely,

Ted Ueda

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question