0

I made a couple of reports that are using a data-source for the parameter values. The same query is specified in available values and default values, so that I can select multiple values at once. The query usage is like this: 

WHERE (Column.Name IN (@Parameter))

However, I get this error:

screenshot of the error

Any ideas what could it be? Other reports using same method work fine, but with this one it doesn't.

Jeroen
  • 60,696
  • 40
  • 206
  • 339
AirWolf
  • 597
  • 7
  • 27
  • Assuming both queries are for the same Database and Table, check in the *Report Parameters* menu that the parameters type and specifications are the same as in the base report. – luchosrock Jan 10 '13 at 12:48
  • Does this question help? http://stackoverflow.com/questions/1256925/ssrs-multi-value-parameter-using-a-stored-procedure – Ian Preston Jan 10 '13 at 12:58
  • Both querys are the same database but uses couple of tables where the params goes in :) the data types are the same – AirWolf Jan 10 '13 at 14:15
  • Lan Preston - no it doesnt :) but thanks for triyng – AirWolf Jan 10 '13 at 19:39
  • It sounds like something is being passed in the parameters (or otherwise) that turns your SQL invalid. Run SQL Profiler against your database then run your report to see what SQL is hitting the database. – Chris Latta Jan 10 '13 at 22:36

1 Answers1

0

So i Ran the SQL Profiler and seen that the errors came from the code that is looking is the param a null (@param is null) that was the mistake because i allready sead in the options to now allow null

Thank you Chris Latta you helped me allot :)

AirWolf
  • 597
  • 7
  • 27