Solved

More than one IF in a VB script.

Posted on 2007-03-27
5
192 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 create VB script that allows me to have more than one IF condition relating to that header - but how ? The If's are unrelated except that the conditions are all in the header.
Thanks.
0
Comment
Question by:brianrodda
  • 3
5 Comments
 
LVL 4

Expert Comment

by:jackmcbarn
ID: 18803201
Can you show me the VB script?  If it's pretty big, post it on EE-Stuff.  Otherwise, post it here.
0
 

Author Comment

by:brianrodda
ID: 18803386
Hi,
Unfortunatley I cant show it exactly for another 10 hours, but its along the lines of:

[Level3PartNumber Header].Visible = true
[Level4PartNumber Header].Visible = true
[Level5PartNumber Header].Visible = true
If LEN (Level3PartNumber) = 0 THEN
[Level2PartNumber Header].Visible = false
ELSE
[Level2PartNumber Header].Visible = true
END IF

and I wish to add something like:

If VAL (PartLocation) = "STORES" THEN
[Level2PartNumber Header].Visible = false
ELSE
[Level2PartNumber Header].Visible = true
END IF

Does that help ?
Thanks.
0
 

Accepted Solution

by:
acekracker earned 50 total points
ID: 18803572
You should be able to use:

If (LEN(Level3PartNumber) = 0) OR (Val(PartLocation) = "STORES" Then
  [Level2PartNumber Header].Visible = false
Else
  [Level2PartNumber Header].Visible = true
End If
0
 

Author Comment

by:brianrodda
ID: 18803604
I'll try it tomorrow and let you know.
Thanks for the input.
0
 

Author Comment

by:brianrodda
ID: 18842051
Hi,
Basically this works and answers my question.
Thanks for the solution.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

This script will sweep a range of IP addresses (class c only, 255.255.255.0) and report to a log the version of office installed. What it does: 1.)      Creates log file in the directory the script is run from (if it doesn't already exist) 2.)      Sweep…
This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
The viewer will learn how to count occurrences of each item in an array.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

786 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