Report Design: While do Loop

Print Page | Close Window

While do Loop

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=942
Printed Date: 02 May 2025 at 12:11pm

Topic: While do Loop

Posted By: ericooi1976
Subject: While do Loop
Date Posted: 29 Jun 2007 at 4:28am

may i know can i know where can i have some sample of

how to use while do syntax and do while syntax in crystal report -formula field?

Thanks

Eric

Replies:

Posted By: jkwrpc
Date Posted: 29 Jun 2007 at 8:45am

Brian has a whole chapter on control structure with examples, here is the link:

http://www.crystalreportsbook.com/Crystal_Reports_XI.asp?Page=7_5 - http://www.crystalreportsbook.com/Crystal_Reports_XI.asp?Page=7_5

Regards

John W.

http://www.CustomReportWriters.net - www.CustomReportWriters.net

Posted By: ericooi1976
Date Posted: 02 Jul 2007 at 12:10am

Hi all master,

I can not get the result that i wish for, any opinion to advice...Thanks

The @Test formula consist of : "abc,def,ghi,".

i want the result to be in the like below:

abc

def

ghi

------- My code ------

Local StringVar AllHour;
Local NumberVar i:=1;
Local StringVar j;
Local NumberVar k:=0;

AllHour := mailto:%7b@Test - {@Test };
k := length(AllHour);

while i <= k and AllHour <> "" do
(j := ToText(Mid(AllHour, i,InStr(i,AllHour,",")-1)) + chr(10);
    i := i + 4;
    );
j;

Thanks a lot

Eric

Posted By: jkwrpc
Date Posted: 04 Jul 2007 at 5:53am

Perhaps I am reading the formula wrong. But you have i = 1 and k = 0 then in the formula you have the While condition as i <= k which is while 1 <= 0 which will never be true. I do not know if this is a problem or not I just found it a bit confusing.

If you have not already done this you may try writing the formula with actual values, ones that are vailid, then run it and see if it gives errors. One it runs as you want then replace the values with the variables.

Regards,

John W.

http://www.CustomReportWriters.net - www.CustomReportWriters.net

Print Page | Close Window