Home » Developer & Programmer » Reports & Discoverer » How to display continual Numbers to another Column (Oracle 10g R2, WinXP)
icon5.gif  How to display continual Numbers to another Column [message #600838] Wed, 13 November 2013 01:02 Go to next message
stalin4d
Messages: 204
Registered: May 2010
Location: Tuticorin, Tamil Nadu, In...
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

Re: How to display continual Numbers to another Column [message #600840 is a reply to message #600838] Wed, 13 November 2013 01:16 Go to previous messageGo to next message
Littlefoot
Messages: 19321
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.
Re: How to display continual Numbers to another Column [message #600841 is a reply to message #600840] Wed, 13 November 2013 01:25 Go to previous messageGo to next message
stalin4d
Messages: 204
Registered: May 2010
Location: Tuticorin, Tamil Nadu, In...
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
Re: How to display continual Numbers to another Column [message #600842 is a reply to message #600841] Wed, 13 November 2013 01:35 Go to previous messageGo to next message
Littlefoot
Messages: 19321
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:

./fa/11281/0/

Re: How to display continual Numbers to another Column [message #600847 is a reply to message #600842] Wed, 13 November 2013 01:57 Go to previous message
stalin4d
Messages: 204
Registered: May 2010
Location: Tuticorin, Tamil Nadu, In...
Senior Member
thanks ya...
let me try this
Previous Topic: Report not opening after submit query
Next Topic: Print problem after Migration reports
Goto Forum:
  


Current Time: Mon Jul 28 18:33:32 CDT 2014

Total time taken to generate the page: 0.10417 seconds