Passing calculated data item as parameter

[Starfish2201]

hi Gurus,

I have this urgent situation and need to fix this issue. I have 3 reports connected through drill through. First report has singletons from which I am have drill-through to the second report. Now I have added a data item in the 2nd report to do some calculation and I am passing it as a parameter to the third report. But if I do so, after 1st report is run, when its giving me the below error when I am doing drill-through to the 2nd report.

"RQP-DEF-0177  An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'. "

The data item has calculation as

Case
when ... then A
When .... then B
etc..

The Parameter in 3rd report has expression as below

?Param? = 'A' and field1 is null and
field2 is null  etc..

Please help me on this.

[MFGF]

Can you add the rest of the error message? From what you have posted, we can't see the specific item the report is complaining about.

MF.