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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

imbed chart within list

Started by fullyii, 09 Sep 2010 09:53:39 AM

Previous topic - Next topic

fullyii

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.?

MFGF

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

fullyii

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?

fullyii

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:

MFGF

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

fullyii

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?

MFGF

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