Solved

VB script filtering for parameter input

Posted on 2007-04-03
5
199 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

912 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now