| problem on report? [message #90011] |
Wed, 29 September 2004 16:15  |
Sam
Messages: 255
Registered: April 2000
|
Senior Member |
|
|
hai
below are my records which already in the database
end_am is varchar2
- date -
- end_am -
- 01-sep-2004 -
- 07:45:00 -
- 02-sep-2004 -
- 08:00:15 -
- 03-sep-2004 -
- 15:30:00 -
- 04-sep-2004 -
- 16:30:30 -
- 05-sep-2004 -
- 11:30:20 -
- 01-oct-2004 -
- 12:15:15 -
- 03-oct-2004 -
- 10:30:16 -
- 05-oct-2004 -
- 14:55:00 -
- 29-oct-2004 -
- 17:20:25 -
i want to produce a monthly report by the end of each month.
when i run my report, it add all the Hours from september to october. let say i want to add for september only not include october. how to do that?
any idea on how to do that
regards
eboy
|
|
|
|
| Re: problem on report? [message #90017 is a reply to message #90011] |
Fri, 01 October 2004 00:46  |
Biljana
Messages: 8
Registered: October 2004
|
Junior Member |
|
|
I am not sure if I understood your question corectly but try to add new column to query, for instance, MONTH_NAME, as function which extracts the month from the date column, for instance TO_CHAR(DATE, 'Month') or convert the date to char and then do SUBSTR to extract the three letters of month.
Then make new Format Exception in Conditional Formatting property of field end_am and make it invisible (set hide the object property to yes) if the new column MONTH_NAME has certain values, like 'oct' or 'October' (watch out for number of blank spaces in month name as a result of function TO_CHAR(DATE, 'Month')).
hope this helps
Bilja
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
