Hi all,
I have a report. In that I have drill through on one item called Product type. When I am clicking on drill throgh link its giving the below error.
An error occurred while performing operation 'sqlPrepareWithOptions' status='-239'.
In my child report I have 10 columns and a filter. This filter is provided in the drill through pane of Main report.
Plesase help on this issue. Is this issue related to database or someother thing.
Thanks in advance.
What does google say?
I have searched in google, but nothing I found related to this exact error.
Yep, that's kind of a generic error. When a drill through causes havoc, I usually do the following:
1. Run target report - does it run on its own? Try giving it, as parameter, a value which it would normally get from the drill-through (Like a product type name). If it fails, something is wrong with the prompt definition.
2. Does drill through fail for all rows, or just some? If for all, and section 1 checks out OK, that probably means drill through settings are off.
3. Try removing the parameter from the drill-through settings (Drill through without passing any parameters). Does it work? If so, your parameter definition was wrong.
Try it out, see if you can find anything, let us know!
The error occurs before running the query(ies) for the target report, in the "sqlPrepare" so look to the parameters that you are passing in.
There is another mention here on cognoise of that same error message ( http://www.cognoise.com/cognoisearchive3000.htm (http://www.cognoise.com/cognoisearchive3000.htm) ) and a recent blog entry http://arulsteg.blogspot.com/ (http://arulsteg.blogspot.com/). The general theme of these suggestions seems to be confusion about datatypes, perhaps a type mismatch in a calculation.
HTH,
Joe
Thankyou Nimrod.
I did as you said. I got know where is the problem. Actually I have the problem in my child report only.