Hello
I get the following error in a very quick test system i created:
An error occurred during local report processing.
An error has occurred during report processing.
Cannot set the command text for data set 'test'.
Error during processing of the CommandText expression of dataset 'test'.
My sql is:
= "select T.testid, T.test from test T " & Iif(Parameters!test1.Value = 1, "", "Where T.testid = " & Parameters!test1.Value)
There is nothing obviously wrong in the code as far as i can see
The parameter 'test1' is of type 'string'
The database 'test' has 2 columns of type 'smallint' and 'Name:nvarchar(50)'
I am at a loss, as this query is really simple, and is similar to the example query set up my microsoft which works fine
Thanks
t.test from test?
You tried running this in sql?
|||Yes, it works fine in sql if you strip out the bits that obviously wont work in query analyser
this works:
= "select T.testid, T.test from test T " & Iif(1 = 1, "", "Where T.testid = 1" )
this does not:
= "select T.testid, T.test from test T " & Iif(1 = 1, "", "Where T.testid = " & Parameters!test1.Value)
why?
there is a parameter called test1
|||Found the answer!
You have to have another table with a different name into which the parameter links (in the section 'available values' / 'from query')
I created another table called test2, et voila! it works
No comments:
Post a Comment