how do you do a loop in Crystal Reports?

[mwhalen]

is there a function that when I perform an evaluation or whatever that it will loop through all the fields in that column in my database?

 

[kenhamady]

Please see the FAQ on what to include in your question.

What do you mean by fields in a column. Typically there is only one field in a column. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[mwhalen]

If I select all contract numbers from a contracts table I am left with a column of contract numbers. Within that column of contract numbers I want to do my loop compare.

 

[kenhamady]

I pointed you to the FAQ so you would tell me your version of CR you are using and if you are working with one of the VB/Crystal techniques. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[mwhalen]

I am using Crystal Reports Professional version 5.0 and VB Enterprise Edition 5

 

[kenhamady]

There is a new iterative feature in V8 that allows programming iteration like "For - Loops". It loops through code, not records.
It won't be in V5.

You can process the records once in the report, and create subreports if you need to do it again.

Sometimes you can accomplish the same things using other Crystal features. What will you be doing in the loop.



Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[mwhalen]

thank you for your continued and patient help. Essentially, this is what I want to do:

If variable 1 in table A = variable 2 in table B then print variable 1 otherwise print variable 2

variable 1 and 2 are string variables but it would not be a big deal to convert them

Also there is no possibility to upgrade our version of Crystal.

 

[kenhamady]

Sorry, I can't help you unless you provide more detail. In Crystal terms there are no variables in tables so I am not sure what you are trying to accomplish. Maybe just different terminology. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[mwhalen]

by variable I mean table field so if the first field in table A is equal to any of the fields in table B... then test to see if the second field in table A is equal to any of the fields in table B and so on

 

[kenhamady]

I don't think that you can do that in CR. Sorry.

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal