Hi,

I like the new version and the concept of mixing SQL and SP data. However I am running into problems when I use mixed data between SP and SQL. (I am using VS 2008) This is my scenario

I have a Sharepoint list query (no conditions) (i.e. ITProjects)

I have a SQL server (called sqlTT) query like this one select * from TimeEntries where (customer in (@Customer!))

then I mix them using a SQLquery join select * from ITProjects as a Join sqlTT as b on a.key = b.key

When I run the report and select more than one customer value I get an error

Query execution failed for dataset 'DataSet1'
The parameterized query '(@Customer_mvp0 nvarchar(13),@Customer_mvp1 nvarchar(13),@Custom' expects the parameter @Customer' which was not supplied.

If I replace the @Customer! with regular text 'value1,value2,value3' it works ok. Also, if I select only ONE value...it works ok

I am not sure what I am doing wrong...

Thanks for your help,

L

Ok thanks for the update. Sure, please keep me posted

Thanks again

L

Thanks, it seems to be working now.

;)

Hi,

For information, forum will no longer be used for providing support. Please send an email to the support address for any support requests. It will automatically open a ticket.

To your problem:

Can you send your query or your report file to the support address email?

Thanks