Values for all the months in the report. [message #89333] |
Tue, 10 February 2004 01:13 |
Rahul Desai
Messages: 26 Registered: March 2002
|
Junior Member |
|
|
Hi everyone,
I need to display all the months and the related data in that particular year. If for a month (say April), if there is no Data then if i query from the db that particular month details wont come. But my reports should display that month(april)and respective details as zero.
Can anybody help me in getting the data.
thanks
|
|
|
|
Re: Values for all the months in the report. [message #89342 is a reply to message #89340] |
Tue, 10 February 2004 22:02 |
Rahul
Messages: 94 Registered: December 1998
|
Member |
|
|
Thanks for replying.
If suppose in a table there is only details for jan and mar
then my report should look like this.
Jan 123 123 123 123
Feb 0 0 0 0
Mar 123 123 123 123
Apr 0 0 0 0
May 0 0 0 0
....................
....................
so on.
Since im generating the report based on the query and only Jan and Mar related details are present rest of the month details wont be displayed. My report should display all the months in order with all the details.
Hope this is clear,
Rahul
|
|
|
Re: Values for all the months in the report. [message #89343 is a reply to message #89342] |
Tue, 10 February 2004 22:17 |
powi
Messages: 5 Registered: January 2004
|
Junior Member |
|
|
I would do something like this:
Create a new table "months" that contains only 12 rows each with one month.
Then I would select all from "months" with an outer join to your statistics-table. You will get one row for every month and the months that are not available in your statistics-table are empty. To avoid an empty column use
nvl(statistic-field,0).
|
|
|