Home » Developer & Programmer » Reports & Discoverer » How to do this in crystal report
How to do this in crystal report Wed, 23 January 2008 00:26
 kdastageer Messages: 28Registered: January 2006 Location: Qatar Junior Member
I would like to print like below.

One
Two
Three
Four
Five
.
.
Ten

using String Array for loop.
Pls give me the soultion.

by
DAS
Re: How to do this in crystal report [message #295666 is a reply to message #295648] Wed, 23 January 2008 01:02
 mshrkshl Messages: 247Registered: September 2006 Location: New Delhi Senior Member
As i think this procedure will be helpful to you.

```declare
n1 number  :=10;
n2 number;
n3 varchar2(20);
begin
for n2 in 1..n1
loop
select to_char(to_date(n2,'J'), 'JSP') into n3 from dual;
dbms_output.put_line(n3);
end loop;
end;
/
```

output

```ONE
TWO
THREE
FOUR
FIVE
SIX
SEVEN
EIGHT
NINE
TEN
```
Re: How to do this in crystal report [message #295689 is a reply to message #295666] Wed, 23 January 2008 01:56
 kdastageer Messages: 28Registered: January 2006 Location: Qatar Junior Member
Hi,

Thanks a lot for your idea.Can you pls suggest me to implement same logic in crystal formula.

Regards,

DAS
Re: How to do this in crystal report [message #295722 is a reply to message #295648] Wed, 23 January 2008 03:18
 kdastageer Messages: 28Registered: January 2006 Location: Qatar Junior Member
Hi,

I will make clear of my question.

StringVar Array x:=["One","Two","Three"];(in crystal report formula)

Output should be:

One
Two
Three

Some idea's like..

For i:=1 to 2 do
(
x[i]=i+1;
)
something like this...
by
DAS
 Previous Topic: how to make sum on multiple feilds of multi queries Next Topic: REP - 0801: (Report Builder Error)
Goto Forum:

Current Time: Mon Jul 24 14:05:43 CDT 2017

Total time taken to generate the page: 0.15798 seconds