Displaying all the months in a year in report

asembereng

How can i display all the months in a year. the format has to be DDMMYYY where DD has to be the last day of the month in a columnar form.

Thanks

kapamarou

Examine the contents of the Date Virtual Table (Table 2000000007) by setting type Month and using something like NORMALDATE(Period End).

And search this forum...

asembereng

I do not have that table.

garak

You doesn't see this table in the Objectdesigner. But you can work with it when you create a new Form based on the table "Date" or you work with it as a Record Variable.

Open the "date" table with a new form (only in designmode) to see, how the entries in this table looks and to know how to work with it (filters, etc)

regards

garak

This is a simple report example

asembereng

Thanks a lot. I have seen the table and i did that report as well. now I am to do similar thing on the Cust. Ledger entry table using posting date. The system does not have all the end of month data for example it will have

31/01/08 D100
29/02/08 D600
30/09/08 D400
31/12/08 D300


but the report should display all the end of months and display a default amount of D500 for those that are not in the Cust/ Ledger table.

How can i do this?