I am facing an issue in my project and require your suggestion for the same. The scenario is explained below -
A report has to be created over a DSO. The table looks similar to this:
Region Transaction Number Transaction Type Contract Start Date(CSD) Work Completion Date (WCD)
1 1000 ZRVP 01/01/2010 01/02/2010 1001 ZRVP 05/01/2010 18/02/2010
1001 ZRVF 05/01/2010 22/02/2010
1001 ZRVF 05/01/2010 26/03/2010
2 1002 ZRVP 04/04/2010 05/05/2010
BEx Report -
Service Calls have to be divided on the basis of the difference of ("Work completion Date"- "Contract Start Date")
Service call is calculates as -> ( (WCD-CSD) <10 )==1)* transactiontype Flag*51 , similarly for other date differences.
User wants a one liner report where he can see region wise report, without transaction numbers being displayed.
The output of the report should looks like this:
Region ServiceCall <10 days Service Calls 10 -20 days Service Calls20-30 days
But this does not gives correct result.
I am not sure how to calculate the date difference for individual transaction and still show it in the report without Transaction number getting populated at run time.
When i add the transaction number to the Rows section, the output is correct.
Any suggestions would really be appreciated.