Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: fullyii on 09 Sep 2010 09:53:39 AM

Title: imbed chart within list
Post by: fullyii on 09 Sep 2010 09:53:39 AM
is it possible to imbed a chart inside a list? If so how do you filter the chart based upon a row value in the list.?
Title: Re: imbed chart within list
Post by: MFGF on 09 Sep 2010 09:57:38 AM
Yes, it certainly is.  Just go to the Toolbox tab on the left, and drag a Chart object in as one of your List columns.  Populate the chart as normal, then go to Data -> Master/Detail Relationships and set up the link between the list query and the chart query so the chart displays data pertinent to each list row.

Regards,

MF.
Title: Re: imbed chart within list
Post by: fullyii on 09 Sep 2010 10:49:45 AM
I setup the report as normal and went into master detail to setup links and when I run a report I am getting a long error message like

CCLAssettError(): Fatal CCL_ASSERT(iParmVal<paramValues.size())......

let me know if you need to see the entire error message and I can provide. Let me know if you have any ideas?
Title: Re: imbed chart within list
Post by: fullyii on 09 Sep 2010 11:14:09 AM
CCLAssertError:0:Fatal: CCL_ASSERT(iParmVal < paramValues.size()); RSV-SRV-0042 Trace back: RSReportService.cpp(804): CCLAssertError: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(241): CCLAssertError: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_Request RSASyncExecutionThread.cpp(766): CCLAssertError: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(211): CCLAssertError: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_Request RSASyncExecutionThread.cpp(816): CCLAssertError: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_Request Execution/RSRenderExecution.cpp(615): CCLAssertError: CCL_RETHROW: RSRenderExecution::execute Assembly/RSDocAssemblyDispatch.cpp(263): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSLayoutAssembly.cpp(64): CCLAssertError: CCL_RETHROW: RSLayoutAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(330): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSReportPagesAssembly.cpp(163): CCLAssertError: CCL_RETHROW: RSReportPagesAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(280): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSPageAssembly.cpp(287): CCLAssertError: CCL_RETHROW: RSPageAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(280): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableRowAssembly.cpp(156): CCLAssertError: CCL_RETHROW: RSTableRowAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(280): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.cpp(109): CCLAssertError: CCL_RETHROW: RSTableCellAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(330): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSTableAssembly.cpp(90): CCLAssertError: CCL_RETHROW: RSTableAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(330): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSTableRowAssembly.cpp(156): CCLAssertError: CCL_RETHROW: RSTableRowAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(280): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.cpp(109): CCLAssertError: CCL_RETHROW: RSTableCellAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(330): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSDocAssemblyDispatch.cpp(280): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSDocAssemblyDispatch.cpp(280): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSDocAssemblyDispatch.cpp(330): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSDocAssemblyDispatch.cpp(280): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSDocAssemblyDispatch.cpp(280): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSDocAssemblyDispatch.cpp(330): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSDocAssemblyDispatch.cpp(280): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSDocAssemblyDispatch.cpp(280): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSDocAssemblyDispatch.cpp(330): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward RSResultSetIterator.cpp(1245): CCLAssertError: CCL_RETHROW: QFSQuery.cpp(199): CCLAssertError: CCL_RETHROW: QFSQuery::Execute v2 CoordinationQFSQuery.cpp(1863): CCLAssertError: CCL_RETHROW: QE QFSQuery.cpp(232): CCLAssertError: CCL_RETHROW: QFSQuery::EXecute v3 QFSPartialDataset.cpp(67): CCLAssertError: CCL_RETHROW: QFSPartialDataset::GetEdgeIterator Source/QEDmSqlResultSet.cpp(1912): CCLAssertError: CCL_RETHROW: QE Source/QESqlParameterValue.cpp(283): CCLAssertError: CCL_THROW:
Title: Re: imbed chart within list
Post by: MFGF on 10 Sep 2010 04:03:07 AM
How did you define the Master-Detail relationship?  Are you using the same item in both queries (list and chart) and linking based on this, or are the items different?

MF.
Title: Re: imbed chart within list
Post by: fullyii on 10 Sep 2010 01:57:11 PM
I think I figured out the problem. The source of the data was from a stroed procedure. I changed everything over to a table and the links are now working. Is there a bug with Master Detail when a stored porocedure is used?
Title: Re: imbed chart within list
Post by: MFGF on 13 Sep 2010 05:32:09 AM
Not as far as I'm aware. My guess is it may have been an issue with a data type mismatch between the linking item used in each query.

Regards,

MF.
Text only | Text with Images