OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » to create sequence

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

to create sequence [message #260510]

Mon, 20 August 2007 03:27

pravin9
Messages: 42
Registered: May 2007

Member

Hi,
I have two col's in a table and while displaying in the output i want to display in this format

1.empno
2.deptno

Can anybody help me with this issue

Thanks,
Praveen

Report message to a moderator

Re: to create sequence [message #260523 is a reply to message #260510]

Mon, 20 August 2007 04:05

sispk6
Messages: 164
Registered: November 2006
Location: pakistan

Senior Member

set their format mask property

Report message to a moderator

Re: to create sequence [message #260524 is a reply to message #260510]

Mon, 20 August 2007 04:07

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

Senior Member
Account Moderator

What are "empno" and "deptno" in your example? Labels? If so, put "1." and "2." in front of them.

However, I believe the solution isn't that easy. Could you write a better example, please? Make a select from Scott's EMP table and show us how would you like to format it.

Report message to a moderator

Re: to create sequence [message #260974 is a reply to message #260510]

Tue, 21 August 2007 07:05

hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE

Senior Member

if we go by the EMP table... the following query will give you the below specified output... if that is what you want.

SELECT '1.'||empno eno, '2.'||deptno dno
  FROM emp
 {WHERE CLAUSE}
 {ORDER BY CLAUSE};

OUTPUT>>>

SQL> SELECT '1.'||empno eno, '2.'||deptno dno
  2    FROM emp;

ENO                                        DNO
------------------------------------------ ---------
1.7369                                     2.20
1.7499                                     2.30
1.7521                                     2.30
1.7566                                     2.20
1.7654                                     2.30
1.7698                                     2.30
1.7782                                     2.10
1.7788                                     2.20
1.7839                                     2.10
1.7844                                     2.30
1.7876                                     2.20

ENO                                        DNO
------------------------------------------ ---------
1.7900                                     2.30
1.7902                                     2.20
1.7934                                     2.10

14 rows selected.

-- let us know.

[Updated on: Tue, 21 August 2007 07:05]

Report message to a moderator

Re: to create sequence [message #261938 is a reply to message #260974]

Fri, 24 August 2007 01:59

pravin9
Messages: 42
Registered: May 2007

Member

Hi,
select no of policies,fees from oe_order_lines_all;

for first row it should display as
1.no of policies
2.fees
when it comes to second row it should be like
3.no of policies
4.fees
for 3rd row
5.no of policies
6.fees

it should go on

and after the repeating frame is completed it should start with the sequence completed for repeating frames for the text boxes it should display as

7.endorsements
8.no of claims

Thanks,
Praveen

Report message to a moderator

Re: to create sequence [message #261942 is a reply to message #260524]

Fri, 24 August 2007 02:12

pravin9
Messages: 42
Registered: May 2007

Member

Hi,
AS you said i need to display it for text boxes and this is how it runs
I have three repeating frames its a matrix report
I for rows and the other for columns and the other to display cell information
I get both the col's data from same table and they should be displayed downwards.till here its ok
After that based on the cell data in the outer repeating frame i place two text boxes which are with respect to cell repeating frame there i need to display the text box as such
select no of policies,fees from oe_order_lines_all;

for first row it should display as
Basic Reissue Refinance
1.no of policies :23
2.fees :150
when it comes to second row it should be like
3.no of policies :20
4.fees :780
for 3rd row
5.no of policies :78
6.fees :690
-----------------------------------------------------------------
here ends the repeating frame data
Next
with in the frame we have text boxes as such which starts exactly where the sequence has been left in the repeating frame
like
7.endorsements
8.mortgage

Thanks,
Praveen

Report message to a moderator

Re: to create sequence [message #261958 is a reply to message #261942]

Fri, 24 August 2007 03:01

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

Senior Member
Account Moderator

So it is a sequence ... you could, for example, include ROWNUM into the SELECT statement. Or, you could create a SUMMARY column; its function would be COUNT and should be broken on REPORT.

Report message to a moderator

Re: to create sequence [message #261993 is a reply to message #261958]

Fri, 24 August 2007 05:33

pravin9
Messages: 42
Registered: May 2007

Member

Hi,
Could you please explain me in detail
If i include Rownum it takes for a row fetched
But my requirement is that for both the coloumns selected it should display as
1.No of policies
2.fees
and for next record fetched
3.no of policies
4.fees

and i hope count might be useful for the number i need to print
for text after the repeating frame

Thanks,
Praveen

Report message to a moderator

Re: to create sequence [message #262088 is a reply to message #261993]

Fri, 24 August 2007 08:08

hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE

Senior Member

here is what u do...

place a summary column of type count on any one of the fields.
lets name this one... cntr1

place 2 formula columns with the details as
cntra... return ((cntr1 * 2)-1)
cntrb... return (cntr1*2)

cntra, cntrb     cntr1
1,     2         1
3,     4         2
5,     6         3
7,     8         4
9,     10        5
11,    12        6

use cntra and cntrb to give the details for your numbering.

Hemavb

[Updated on: Fri, 24 August 2007 08:10]

Report message to a moderator

Re: to create sequence [message #262418 is a reply to message #262088]

Mon, 27 August 2007 00:16

pravin9
Messages: 42
Registered: May 2007

Member

Hi,

Thanks hema it worked

Report message to a moderator

Re: to create sequence [message #262420 is a reply to message #260510]

Mon, 27 August 2007 00:25

hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE

Senior Member

you are welcome. Cool

Report message to a moderator

Previous Topic:	plz senior members reply for questions in reports as u reply in developer forms
Next Topic:	Tab Order in Parameter Form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 08:56:16 CST 2025