COGNOiSe.com - The IBM Cognos Community

Hi,

I'm creating a master detail report (using option filtered detail query) but am having problems with setting up the master detail relationship. I took the tutorial & even looked in my text books that I got from the Authoring classes, but still no luck.Ã,  In all the examples I've been able to find using the master detail report, the relationship coded in the expression Definition window is always using only one item for the criteria.

For example:Ã,  Ã, Master.Item1 = Detail.Item1

In my report I need 2 items to match, in order to give me the correct detail record.Ã, 

For example:

(Master.Item1 = Detail.Item1) AND (Master.Item2 = Detail.Item2)

However, when I add more than one criteria in the expression definition window I cannot get the report to execute.
I can validate both the expression & the report without errors but when I go to run the report it dies. I will paste the error message below.

Any ideas ? Much Thanks -

ERROR MESSAGE:
-----------------------------------------------------
UDA-SQL-0107 A general exception has occurred during the operation "sqlPrepareWithOptions".
RSV-SRV-0025 Unable to execute this request.
Trace back:
WPBIBusMethod.cpp(190): UDASQLException: CCL_CAUGHT: WPBIBusMethod::run
WPReportExecutionMethod.cpp(180): UDASQLException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions
WPExecuteRequestThread.cpp(169): UDASQLException: WPExecuteRequestThread::checkException
WPEngine.cpp(946): UDASQLException:
WPController.cpp(263): UDASQLException: CCL_RETHROW: WPController::executeRendering()
LWDataRetrievalEngine.cpp(789): UDASQLException: CCL_RETHROW: LWDataRetrievalEngine::iterateResultSets
LWDResultSetProcessor.cpp(423): UDASQLException: CCL_RETHROW: LWDResultSetProcessor::getDetailQueryProcessor
Source/QESqlRequest.cpp(649): UDASQLException: CCL_RETHROW:

Try to validate your report and post the error message you receive.  That will sometimes give a better explanation of the problem.  Thanks.

Add 2 filters instead of placing your AND between the two.

Make sure none of the fields you use for linking are calculations... specially concatenations... for some reason I found this problematic.

cheers