Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Multiple Value in Report Parameters

Status
Not open for further replies.

jpower69

Programmer
Feb 5, 2008
54
US
I'm having a problem using the multi-value check box in the report layout parameters section. I have the following setup
for the user to select multi-semesters for a report..
properties: Nmae: semester, data type = string, Prompt = semester;multi-value box is checked;Available values
from query get semester; value field:semesterID; Label field:description.

This is the code that is getting executed:
if (charindex('-2',@semester) = 0 ) and (charindex('-3',@semester) = 0)
begin
-- Select Chosen Semester
set @wheresemester = ' And semesterID IN ( ' + @semester +')'
end
Problem is that the code works if I select ALL semesters or
if i slect semester = FA2008; it does not work if i selected semester FA2008,SP2008.
I get the following error"CONVERSION FAIL WHEN CONVERTING THE VARCHAR VALUE 4,7 TO DATA TYPE INT"

Can anyone tell me what I am missing here....it is probably staring right at me but i can't see it..

thanks in advance for any information
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top