[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

VB script filtering for parameter input

Posted on 2007-04-03
5
Medium Priority
?
207 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
4 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
In a question here at Experts Exchange, a member was looking for "a little app that would allow sound to be turned OFF and ON by simply clicking on an icon in the system tray". This article shows how to achieve that, as well as providing the same OF…
The viewer will learn how to dynamically set the form action using jQuery.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
Suggested Courses

590 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