| Report Generation [message #78090] |
Tue, 15 January 2002 04:31  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
