If you are unable to create a new account, please email support@bspsoftware.com

 

Unable to drillthrough from a Report used DMR package to a relation Report.

Started by SSNCOG, 27 Apr 2010 08:09:50 AM

Previous topic - Next topic

SSNCOG

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

MFGF

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.
Meep!

SSNCOG

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

MFGF

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.
Meep!