Dear Friends,
I have to make a cross Tab Report in my Application, I am new to this Requirement(Cross Tab).
please need your help.my report format is as below.
Fromdate: ToDate:
| MONTH | Oct-10 | Nov-10 | Dec-10 | Jan-11 | Feb-11 | Mar-11 | TOTAL | NET SALES | COMISSION | SIX MONTHLY MGM | BAL TO PAY | SALES REQUIRED |
| |
|
|
|
|
|
| total qu val |
|
|
| |
| |
|
|
|
|
|
| 637500 | 566666.7 | 85000 | 80000 | -5000 | -37500 |
| |
|
|
|
|
|
|
|
|
|
|
| |
| |
|
|
|
|
|
|
|
|
|
|
| |
| |
|
|
|
|
|
|
|
|
|
|
| |
| |
|
|
|
|
|
|
|
|
|
|
| |
| |
|
|
|
|
|
|
|
|
|
|
| |
| TOTAL | | | | | | | | | | | | |
| |
|
|
|
|
|
|
|
|
|
|
| |
| |
|
|
|
|
|
|
| SALES REQURED |
| |
| |
|
|
|
|
|
|
|
|
|
|
| |
| |
|
|
|
|
|
|
|
|
|
|
| |
| | | | | | | | | | | | | |