Home » Developer & Programmer » Reports & Discoverer » Sequence Number (Reports 6i)
Sequence Number [message #310410] Tue, 01 April 2008 02:48 Go to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
How to display sequence number in report?

Re: Sequence Number [message #310441 is a reply to message #310410] Tue, 01 April 2008 05:12 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

create a summary column (count) on any unique field of your report.
Re: Sequence Number [message #310450 is a reply to message #310410] Tue, 01 April 2008 05:33 Go to previous messageGo to next message
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
Re: Sequence Number [message #310479 is a reply to message #310410] Tue, 01 April 2008 07:08 Go to previous messageGo to next message
*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

Re: Sequence Number [message #310486 is a reply to message #310479] Tue, 01 April 2008 07:19 Go to previous messageGo to next message
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.
Re: Sequence Number [message #310614 is a reply to message #310479] Tue, 01 April 2008 15:19 Go to previous messageGo to next message
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).
Re: Sequence Number [message #310700 is a reply to message #310410] Wed, 02 April 2008 02:26 Go to previous message
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

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


Current Time: Sat Dec 07 00:11:30 CST 2024