I have a report with a prompt page which was working fine .based on requirement a hardcode filter (required)which was existing in the report query was added to the queries which are being used by the prompts in the prompt page.when this filter was added the following error is displayed.(prompt page has prompts which uses cascading,when the prompt is trying to cascade then its returning this error)
RSReportService.cpp(629): RSNoFormatException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(177): RSNoFormatException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_Request RSASyncExecutionThread.cpp(562): RSNoFormatException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(192): RSNoFormatException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_Request RSASyncExecutionThread.cpp(612): RSNoFormatException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_Request RSReportFunctions.cpp(458): RSNoFormatException: CCL_THROW: ::ReportOutput
Same error is displayed when the newly added filter is required or optional.one more thing is field used to create the same filter conditions is being used from prompt tables in the prompt query and other table in the report query.
Any ideas what the issue is.