Home » Developer & Programmer » Reports & Discoverer » How to do this in crystal report
How to do this in crystal report [message #295648] Wed, 23 January 2008 00:26 Go to next message
kdastageer
Messages: 28
Registered: 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 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: 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 Go to previous messageGo to next message
kdastageer
Messages: 28
Registered: 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 Go to previous message
kdastageer
Messages: 28
Registered: 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: Sat Nov 30 03:36:26 CST 2024