Crystal Reports Online Training

Learn Online, Anytime, Anywhere

Step-by-step online tutorials.

8.11 For Next Loop, While-Do Loops

Looping Structures

Looping structures let you execute a block of code multiple times. The number of times this code block is executed depends upon the type of loop used and what happens within the code block. The looping structures covered are: For Next, While, and the various Do loops.

For Next Loop

The For Next loop uses the standard VB .NET syntax of using the For statement followed by a variable and the start and ending range. You have to decide in advance how many times the code block gets executed.

The default loop increment is 1. Use the Step keyword to define a new increment. Terminate the For block using the Next statement. Putting the variable name after the Next statement is optional. You can prematurely exit the loop by using the Exit For statement.

For var = start To end Step increment
...code...
If condition Then
Exit For
End If
Next

While and Do Loops

The While and Do loops all follow the standard VB .NET syntax. The While block is terminated with a Wend statement. The Do loops are terminated with a Loop statement. The While keyword is used to continue looping as long as the condition evaluates to True. The Until keyword is used to continue looping when a condition evaluates to False. You can exit a Do loop with an Exit Do statement.

Code template for While … Wend:

While true_condition
...code...
Wend

Code template for Do While … Loop:

Do While true_condition
...code...
Loop

Code template for Do Until … Loop:

Do Until false_condition
...code...
Loop

Code template for Do … Loop While:

Do
...code...
Loop While true_condition

Code template for Do … Loop Until:

Do
...code...
Loop Until false_condition