Hi,
We have a dashboard built on DMR package. I am trying to drill through on a crosstab column which has been used code and displayed Discription.This discription is an attribute. I am uanble to pass through this column data item value to a relational target report and getting below error.
QE-DEF-0260
Parsing error before or near position: 9 of:"20082009"
QE-DEF-0261 OQP - Parsing text: 20082009RSV-SRV-0042 Trace back:RSReportService.cpp(792): QEExceptionExtended: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(241): QEExceptionExtended: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(774): QEExceptionExtended: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(211): QEExceptionExtended: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(824): QEExceptionExtended: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestDTProviderQuery.cpp(2394): QEExceptionExtended: CCL_RETHROW: DTProviderQuery::getPowercubeTimeCategoryDateRangeQFSSession.cpp(688): QEExceptionExtended: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(686): QEExceptionExtended: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(643): QEExceptionExtended: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(541): QEExceptionExtended: CCL_RETHROW: QFSConnection::Metadata()QFSMetadataQuery.cpp(124): QEExceptionExtended: CCL_RETHROW: QFSQuery::Execute v2Source/QUYyError.cpp(251): QEExceptionExtended: CCL_THROW: QE
note: the value 20082009 is tha value that i need to pass to target report.
Environment: C 8.4 ,SQL Server.
Ca any body help me on this.
Thanks,
SSNCOG
Hi,
What data type is the passed value? Is there a parameter filter defined on the target relational report? If so, how is the filter expression coded, and what data type is the column being filtered?
Regards,
MF.
Hi MF,
Thanks for reply.
Filter I have used in target report is
[Target Data item]=?CDvalue?
Data Type for this dataitem is characterLength16
I am passing a dataitem value from source report to ?CDvalue? and set Property to pass as 'Member caption'.I tried with out this property as well
Data Type for Source dataitem which is the source for target prompt is Character (String)
Thanks,
Siva
Hi,
Could you try a quick test: change the filter on the target report to filter on the code rather than the description, then simply pass the relevant level from the source report. Does this work?
MF.