I get this error because of the case statement included in the query item used for my year prompt use value. the prompt does what I want but combined with the month prompt which points directly to a table I get the error message.
here is the case statement case when ([Stat]=1) then ('Current Period') else ([Yr]) end
And the error I get is
RSReportService.cpp(747): RSQFCommandException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): RSQFCommandException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_RequestRSASyncExecutionThread.cpp(854): RSQFCommandException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(311): RSQFCommandException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): promptPagingForward_RequestRSASyncExecutionThread.cpp(910): RSQFCommandException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(585): RSQFCommandException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(325): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): RSQFCommandException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(419): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(178): RSQFCommandException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(369): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageSetAssembly.cpp(467): RSQFCommandException: CCL_RETHROW: RSPageSetAssembly::assembleAssembly/RSAssembly.cpp(686): RSQFCommandException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(746): RSQFCommandException: CCL_THROW: RSAssembly::createListIterator.
I have searched everywhere for help and I can't seem to find a solution, somebody please help!!