Home » Developer & Programmer » Forms » Report Generation
Report Generation [message #78090] Tue, 15 January 2002 04:31 Go to next message
Godwin
Messages: 37
Registered: January 2002
Member
Hello,
I have a table A(name,sex,age)and i want a report to be generated in the ff format:
No. Name Age
1. Ofoe 25
2. Bob 19
3. Alex 20
My problem is that how do I write a query such that the query will contain a counter that will produce the
No. column base on the number of records retrieved by the query. The No. column should not be a table column and i do not want to attach a sequence to table A too.
e.g
select count(*) from a
so that i will have somthing like
No. Name Age
count-(count-1) ofoe 25
Or is there a special builtin function
Am using Developer6.0 Report 6
Re: Report Generation [message #78091 is a reply to message #78090] Tue, 15 January 2002 06:03 Go to previous message
Shilpa
Messages: 59
Registered: November 2001
Member
In the report:

Create a query with the following sql statement.

SELECT NAME,AGE
FROM TABLE A;

Create a Summary Column and place it in the same group.

The properties of the summary column for
Function ---> Count
Source ----> NAME
Reset at ----> Report.

Create a field in the layout editor to map to the summary column that was created earlier.

Create a text item next to the field that was created above and type '.'.

If you need more info let me know.I can send you a report based on emp table.
Previous Topic: INSTALLING DEVELOPER 2000 WITH ORACLE 8
Next Topic: *** Problem with DUAL ***
Goto Forum:
  


Current Time: Tue Jun 02 10:27:49 CDT 2020