EDIT: I GOT IT TO WORK!
My response time data item "response time" was a calculation "(end time - start time)" and it would not let me conditionally format that data item as anything without throwing an error. What I did was created a new data item called "response time 2" and all I did was throw "response time" inside, so that it was just duplicating my response time data item, but AFTER it had been calculated.
Then I was able to replace the "response time" data item in my crosstab with "response time 2" and then was able to format it using a number (rather than an interval). The number I found out read the time as milliseconds, so I wanted everything over 9 minutes to be highlighted, therefore I used the number 540,000 in the conditional formating and VOILA! It works!
Original problem below:
Hi all, first post here.
I have a report that is counting and averaging response times within a cross tab. It runs fine but I have been trying to conditionally format the response time data item to highlight the background when the response time is greater than 9 minutes. My response time data item is setup as a "Time Interval" in the crosstab and displays correctly. However when I try to conditionally format it using the "interval range" and I enter in 9 minutes as the time, I am then presented with this error upon running the report:
CRX-API-0003
A data type error ocurred at or near the position '48' in expression: '[Avg JP Time by Hour of Day].[Completion Time1] >= string2DTinterval("0 00:09:00.000") '. The operand types ('double,interval2') for operator '>=' are not compatible.
RSV-SRV-0042 Trace back:RSReportService.cpp(805): crxException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(265): crxException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(787): crxException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224): crxException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_RequestRSASyncExecutionThread.cpp(837): crxException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(606): crxException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(277): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(77): crxException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(176): crxException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageSetAssembly.cpp(414): crxException: CCL_RETHROW: RSPageSetAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageGroupAssembly.cpp(483): crxException: CCL_RETHROW: RSPageSetAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(300): crxException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(173): crxException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(135): crxException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(110): crxException: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableRowAssembly.cpp(173): crxException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(135): crxException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(294): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyRom/RSConditionalExpression.cpp(210): crxException: CCL_RETHROW: RSConditionalExpression::evaluateExpressionRSExpression.cpp(140): crxException: CCL_THROW: RSExpression::compile
I'm still quite new to cognos. Where should I start looking?
Thank you!
Charles