Home » Developer & Programmer » Reports & Discoverer » to create sequence
to create sequence [message #260510] Mon, 20 August 2007 03:27 Go to next message
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
Re: to create sequence [message #260523 is a reply to message #260510] Mon, 20 August 2007 04:05 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
set their format mask property
Re: to create sequence [message #260524 is a reply to message #260510] Mon, 20 August 2007 04:07 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: to create sequence [message #260974 is a reply to message #260510] Tue, 21 August 2007 07:05 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: to create sequence [message #261942 is a reply to message #260524] Fri, 24 August 2007 02:12 Go to previous messageGo to next message
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
Re: to create sequence [message #261958 is a reply to message #261942] Fri, 24 August 2007 03:01 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: to create sequence [message #261993 is a reply to message #261958] Fri, 24 August 2007 05:33 Go to previous messageGo to next message
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
Re: to create sequence [message #262088 is a reply to message #261993] Fri, 24 August 2007 08:08 Go to previous messageGo to next message
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 Go to previous messageGo to next message
pravin9
Messages: 42
Registered: May 2007
Member
Hi,

Thanks hema it worked
Re: to create sequence [message #262420 is a reply to message #260510] Mon, 27 August 2007 00:25 Go to previous message
hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE
Senior Member
you are welcome. Cool
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:
  


Current Time: Sat Dec 10 16:55:01 CST 2016

Total time taken to generate the page: 0.06331 seconds