If I want to display a report with flexible/dynamic rows and columns, I must use cross tab report?
I tried the cross tab report, but some functions are limited. Example: I cannot insert record number inside the cross tab.
If I want to display the following attendance report (1 means present on that date while 0 means absent on that date), how can I achieve that?
Example Report:
------------------------------------------------------------------------------------
| Date
No. Emp Name | 23/11 24/11 25/11 26/11 27/11 %
------------------------------------------------------------------------------------
1. Employee A | 1 1 1 1 1 100
2. Employee B | 0 1 1 1 1 80
------------------------------------------------------------------------------------
% | 50 100 100 100 100