OraFAQ Forum: Reports & Discoverer » How to display continual Numbers to another Column

Home » Developer & Programmer » Reports & Discoverer » How to display continual Numbers to another Column (Oracle 10g R2, WinXP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to display continual Numbers to another Column [message #600838]

Wed, 13 November 2013 01:02

stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...

Senior Member

Hi,

I have a Report which displays 3 columns with data below;

Itemid | Description | Amount

123 xxx xxx
124 xxx yyy
125 xxx zzz
nnn zzz zzz

ok wel now i want to display the above like;

Itemid | Itemid | Description | Amount

123 127 xxx xxx
124 128 xxx yyy
125 129 xxx zzz
126 1210 ttt zzz

so what i want is;

another same itemid field is to be put near by and the continuity should flow from the next field...
because for 1 page it should show 100 records, another 100 records in the same next field but continually!

is that possible how to achieve this?

Stalin

Report message to a moderator

Re: How to display continual Numbers to another Column [message #600840 is a reply to message #600838]

Wed, 13 November 2013 01:16

Littlefoot
Messages: 21647
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Are you saying that items 124 and 128 share the same description and amount? In other words, are these information related in any way? Doesn't seem to be so.

Report message to a moderator

Re: How to display continual Numbers to another Column [message #600841 is a reply to message #600840]

Wed, 13 November 2013 01:25

stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...

Senior Member

Littlefoot wrote on Wed, 13 November 2013 12:46

Are you saying that items 124 and 128 share the same description and amount? In other words, are these information related in any way? Doesn't seem to be so.

description and amount field is not needed i just put it for a ref. so it should be like;

itemid itemid itemid

1 6 11
2 7 12
3 8 13
4 9 14
5 10 15

Report message to a moderator

Re: How to display continual Numbers to another Column [message #600842 is a reply to message #600841]

Wed, 13 November 2013 01:35

Littlefoot
Messages: 21647
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Piece of cake.

Create a report; I chose

select level itemid
from dual
connect by level <= 50

Let wizard create layout.

Then modify:
- both frame's and repeating frame's vertical & horizontal elasticity to "variable"
- repeating frame's print direction to "down/across"

Run the report; this is the result:

/forum/fa/11281/0/

Attachment: rep_down_across.JPG
(Size: 15.11KB, Downloaded 462 times)

Report message to a moderator

Re: How to display continual Numbers to another Column [message #600847 is a reply to message #600842]

Wed, 13 November 2013 01:57

stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...

Senior Member

thanks ya...
let me try this

Report message to a moderator

Previous Topic:	Report not opening after submit query
Next Topic:	Print problem after Migration reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 19 13:25:55 CST 2021