OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Sequence Number (Reports 6i)

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

Sequence Number [message #310410]

Tue, 01 April 2008 02:48

*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh

Senior Member

How to display sequence number in report?

Report message to a moderator

Re: Sequence Number [message #310441 is a reply to message #310410]

Tue, 01 April 2008 05:12

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

create a summary column (count) on any unique field of your report.

Report message to a moderator

Re: Sequence Number [message #310450 is a reply to message #310410]

Tue, 01 April 2008 05:33

spmano1983
Messages: 269
Registered: September 2007

Senior Member

Tell me what your requirement exactly...

Do you want only sequence number then you can use this query in your data model..

SELECT ROWNUM
FROM ( SELECT 1 FROM DUAL
GROUP BY CUBE(1,2,3,4,5,6,7,8,9,10) )
WHERE ROWNUM <= 10

If anything revert back.

Thanks
Mano

Report message to a moderator

Re: Sequence Number [message #310479 is a reply to message #310410]

Tue, 01 April 2008 07:08

*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh

Senior Member

Thanks Usman thanks mano

spmano1983

i have below table

ARN_NO VARCHAR2(15)
ITEM_DESCRIPTION VARCHAR2(100)
MANUFACTURER VARCHAR2(60)
PART# VARCHAR2(30)
SERIAL# VARCHAR2(60)
DEPT VARCHAR2(20)
PROCURED_BY VARCHAR2(30)
CATEGORY VARCHAR2(15)
OPERATIONS VARCHAR2(15)
QTY NUMBER(3)

ARN_NO MANUFACTURER
--------------- --------------------
2541 SEIMENS
1654 NOKIA
2151 HP COMPAQ
1653 NOKIA
2151 WESTERN DIGITAL

when i generate report the auto serial number will generate before arn_no as below example

----------------------------------------------
S.No ARN_NO MANUFACTURER
---- ----------- -------------------------
1 2541 SEIMENS
2 1654 NOKIA
3 2151 HP COMPAQ
4 1653 NOKIA

this is what i want S.No sequence autogenrate numbers in reports
how can i do?

and the second thing i wanna to enter a name in report which is not database item. through a parameter i can manage ARN_no but when ever i print the report it should print the name as well what i enter in the non database item

i.e. Delivered <name should display here>

Regards

Report message to a moderator

Re: Sequence Number [message #310486 is a reply to message #310479]

Tue, 01 April 2008 07:19

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

thats what i told you.did u tried that?.create a summary column and set count on
ARN_NO and place it in layout as u want.

Report message to a moderator

Re: Sequence Number [message #310614 is a reply to message #310479]

Tue, 01 April 2008 15:19

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

Senior Member
Account Moderator

As usually, you aren't the very first user who wants to display sequence number. If you think that there's something wrong with solutions people already suggested (just being curious: what exactly you did not like?), feel free to search the board; you'll (more or less) find the same solutions as seen in this thread.

Quote:

and the second thing i wanna to enter a name in report which is not database item. through a parameter i can manage ARN_no but when ever i print the report it should print the name as well what i enter in the non database item

i.e. Delivered <name should display here>

There are a few possible solutions (that I can remember of and which are quite simple): the simplest is to open Paper Layout and type

Delivered &parameter_name

Ampersand (&) will display parameter's value.

Or, you could create a field whose source is this very parameter.

Or, you could even create a formula column which would return parameter's value and display formula's value.

Or, you could create another parameter and set its value in the AFTER PARAMETER FORM trigger as (for example)

RETURN 'Delivered ' || :parameter_name;

Personally, I use the first approach whenever possible (as it requires NO coding at all and is easy to implement).

Report message to a moderator

Re: Sequence Number [message #310700 is a reply to message #310410]

Wed, 02 April 2008 02:26

spmano1983
Messages: 269
Registered: September 2007

Senior Member

Hi,
If ARN_NO is unique then just you create one summary column for count and source is ARN_NO and place it in layout model.. otherwise

just you take rownum in datamodel like,

select rownum,empno,ename from emp;

Thanks
Mano

Report message to a moderator

Previous Topic:	Reports Zoom in Previewer.
Next Topic:	date

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 22:40:06 CST 2024