Query execution failed for data set

Question

Query execution failed for data set

L Louie

SSC Rookie

Points: 43
More actions
January 29, 2007 at 2:23 pm

#171948

hi. I have a report which I pass a parameter to. I checked the url and the parameter does get passed but is not being pickup by the report. The report is set to receive this parameter.
I get this error - "Query execution failed for data set 'DSAirpromo'. Any ideas as to what I need to do. I pass the paramenter using a Dot Net project. Thanks.
Linda

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Aaron Ingold SSCrazy Eights Points: 9070 More actions · Answer 1

It might be worthwhile to try running profiler on the database server at the time of execution and seeing if you can capture the exact SQL statement that is being passed to the server. That should help in debugging the issues. Likely it's just not parsing the parameter in right.

L Louie SSC Rookie Points: 43 More actions · Answer 2

I ran the profiler and it did show the value that I pass it.

<Name>PANumber</Name>

<Type>String</Type>

<Nullable>False</Nullable>

<MultiValue>False</MultiValue>

<State>HasValidValue</State>

</Values>

</Parameter>

</Parameters>'

This is what is shown in the url:

http://finportal3/ReportServer/Pages/ReportViewer.aspx?/AirpromoReport/PADetail&PANumber=2305

Anything else that you suspect? Thanks for your help.

Aaron Ingold SSCrazy Eights Points: 9070 More actions · Answer 3

What's the data type of the column it's being compared against. That provides a value which could be evaluated just as easily as an integer (even though it's a string in this case). Do the datatypes of the table data coincide with a string data type (char/varchar/nvarchar, etc...)?

L Louie SSC Rookie Points: 43 More actions · Answer 4

The datatype on the table is varchar and I'm passing it a string.

When I changed the report parameter to non-hidden so I type in the value, the report does show up. The report fails when I try to pass it a string value.