| Report Rowcount [message #90409] |
Wed, 16 February 2005 07:56  |
Prince
Messages: 32
Registered: December 2001
|
Member |
|
|
How do I add a row count to my report, can anyone please help? I am working with 9i
column column column
------- ------- -------
1 1 1
2 2 2
4 5 7
Total Rows: ........
|
|
|
|
| Re: Report Rowcount [message #109136 is a reply to message #90409] |
Tue, 22 February 2005 08:59  |
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
|
Senior Member |
|
|
Do you need a running row count or just a count of how many rows were returned by the query? If you just need a count of the rows you can attain this easily by going into the data model of your report, creating a summary column (the tool beneath the PL/SQL tab in the Tool Palette) outside of your query. You now can set up the features of this summary column. Open up its property palette and change FUNCTION from SUM to COUNT and change SOURCE from <NULL> to any item that will be returned in every row and make sure RESET AT is set to REPORT. Now you can reference that count in a field in your report.
HTH,
Steve
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
