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.
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.