| Please Reply Soon [message #89082] |
Fri, 29 August 2003 04:55  |
Kanwar Abid
Messages: 3
Registered: August 2003
|
Junior Member |
|
|
I m making report which will show absent days(date) of a employee between one month. I have a table "atd"
which have values of present dates like
01-aug-03
02-aug-03
04-aug-03
-----
-----
----- and so on
I want to print 03-aug-03 because it is not available in the table
|
|
|
|
| Re: Please Reply Soon [message #89126 is a reply to message #89082] |
Fri, 10 October 2003 06:47  |
AbdulKhaliq
Messages: 11
Registered: August 2003
|
Junior Member |
|
|
u hv to place 31 function columns in the report's datamodel. every column represent the day of month accordingly. and then extract the data from database other wise mark that column as Absent 'A'.
i.e.
in cf_1st function (representing 1st day of the month)
extract only 01-aug-03 and if exist in the table then this function should return 'P' else 'A'.
i think u b the clear abt the solution.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
