Please correct my JOIN expression in SSRS
Hello, Could please correct my "Join" expression in SSRS, FROM Tablename WHERE Product=" & "'" &JOIN(Parameters!Product.Value,",")&"' AND["& "Group]= '"& JOIN(Parameters!Group.Value,",")&"'" I did select Multi select check box in the Parameter properties. When i select single value it is retriving the data, whenver i select multi value it doen't return any value. could please help me. Thanks.
November 11th, 2011 7:58am

your sql statement needs to read "in" and not "="
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2011 8:01am

Hi RP Put In & Bracket as below. Please put "(" & ")" Brackets at write position else give error. FROM Tablename WHERE Product IN " & "'"( &JOIN(Parameters!Product.Value,",")& )"' AND["& "Group]= '"& JOIN(Parameters!Group.Value,",")&"'" Suhas | MCP | MCTSMark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful.
November 11th, 2011 8:14am

Both of the = need to be in Deb
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2011 8:35am

your sql statement needs to read "in" and not "="
November 11th, 2011 3:45pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics