Solved

VB script filtering for parameter input

Posted on 2007-04-03
5
202 Views
Last Modified: 2010-04-16
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
0
Comment
Question by:brianrodda
  • 2
5 Comments
 

Expert Comment

by:acekracker
ID: 18844577
My first reaction is that @Location needs to be in {} like this: {@Location}
0
 

Author Comment

by:brianrodda
ID: 18844913
So a parameter needs to be in {} curly brackets ? I'll try it......
0
 

Author Comment

by:brianrodda
ID: 18881636
Turns out it is in () brackets and without the @.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 19300233
PAQed with points refunded (250)

Computer101
EE Admin
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Learn the basics of strings in Python: declaration, operations, indices, and slicing. Strings are declared with quotations; for example: s = "string": Strings are immutable.: Strings may be concatenated or multiplied using the addition and multiplic…
The viewer will learn how to count occurrences of each item in an array.

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question