How to deal with the following issue in Cognos

Element 'selectOptions' is not valid for content model: 'All(style,defaultSelections,conditionalStyles,conditionalRender,XMLAttributes)' RSV-SRV-0042 Trace back: RSReportService.cpp(629): RSException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(177): RSException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_Request RSASyncExecutionThread.cpp(562): RSException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(383): RSException: CCL_CAUGHT: RSASyncExecutionThread::handlePromptException ExecutionContextImpl/RSGeneratedPromptPageExecutionContext.cpp(285): RSException: CCL_RETHROW: RSReportDOMBuilder.cpp(151): RSException: CCL_THROW: RSReportDOMBuilder::parse

helen.zhao
Profile Answers by helen.zhao Questions by helen.zhao
Nov 12th, 2007
3
8974

Questions by helen.zhao

Cognos

Answer

Showing Answers 1 - 3 of 3 Answers

greglvaughan
Profile Answers by greglvaughan

Aug 7th, 2008

Kind of okey, but If the problem is because you are trying to fill a value prompt with static values without setting a default (this is one way to fix this) you can create a new SQL query that is just a set of values (your static values) and union them together (ie..select 'CA' as value, 'CA' as display union...)

Once this is done set the caching to yes in this query and then assign the values from the query to the value prompt..

this worked...