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

Former Member
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