Solved

VB script filtering for parameter input

Posted on 2007-04-03
5
203 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Batch, VBS, and scripts in general are incredibly useful for repetitive tasks.  Some tasks can take a while to complete and it can be annoying to check back only to discover that your script finished 5 minutes ago.  Some scripts may complete nearly …
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 …
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

732 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