- SAP Community
- Products and Technology
- Technology
- Technology Q&A
- Time range parameter doesn't work in JRC
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Time range parameter doesn't work in JRC
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 09-09-2008 1:03 AM
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
- SAP Managed Tags:
- SAP Crystal Reports,
- SAP Crystal Reports, version for Eclipse
Accepted Solutions (1)
Accepted Solutions (1)
ted_ueda
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Answers (0)
- Workload Analysis for HANA Platform Series - 2. Analyze the CPU, Threads and Numa Utilizations in Technology Blogs by SAP
- Deploying SAP S/4HANA Containers with Kubernetes in Technology Blogs by SAP
- pass range value via URL Parameter in SAC in Technology Q&A
- Safeguard your SAP BW conversion with SAP Enterprise Support services in Technology Blogs by SAP
- Announcement: New release of content and central entry point for SAP BTP Solution Diagrams in Technology Blogs by SAP
| User | Count |
|---|---|
| 95 | |
| 13 | |
| 13 | |
| 11 | |
| 11 | |
| 7 | |
| 5 | |
| 5 | |
| 4 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.