VB script filtering for parameter input

Hi,
I am using a report designer (C1 Report Designer) that uses SQL behind it. In the report I have several group headers. Within each header I have VB script that does various things. What I want to do is modify the script below to filter out lines that arent the same as the parameter "@Location" - but how ?
Thanks.

[SubCompPartNumber Header].Visible=true
If (SubCompLocation)=(@Location)
THEN
[SubCompPartNumber Header].Visible=true
ELSE
[SubCompPartNumber Header].Visible=false
END IF
brianroddaAsked:
Who is Participating?
 
Computer101Commented:
PAQed with points refunded (250)

Computer101
EE Admin
0
 
acekrackerCommented:
My first reaction is that @Location needs to be in {} like this: {@Location}
0
 
brianroddaAuthor Commented:
So a parameter needs to be in {} curly brackets ? I'll try it......
0
 
brianroddaAuthor Commented:
Turns out it is in () brackets and without the @.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.