| Monthly report? [message #89324] |
Sun, 08 February 2004 21:37  |
fatimah
Messages: 9
Registered: February 2004
|
Junior Member |
|
|
Hello everybody..
i have a problem in creating a monthly report using report builder...i just knew how to create a daily one. So, i'm asking from anybody who could help me...what will be the coding to build a monthly report? or maybe there's another easy way of doing it rather than coding?
|
|
|
|
|
|
| Re: Monthly report? [message #89519 is a reply to message #89518] |
Fri, 30 April 2004 22:26  |
edan
Messages: 2
Registered: April 2004
|
Junior Member |
|
|
Hi krishna,
i juz discovered how to view a monthly report from a friend...Try using a report parameter form.. In the SQL Query Statement, type in ur select statement then at the end key in
"where to_char(date_field, 'fmMonth') = :P_MONTH; and to_char(date_field, 'RRRR' = :P_YEAR"
OR
after the select statement, put at the end:
"where date_field between :P_FROMDATE and :P_TODATE" (But this statement i neva use b4...)
hope u understand what i'm saying...
sayounara.... (",)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
