I have developed this crystal report with Visual Studio 2005.
The report is used excel as input.
(please look at attachment files)
I used crosstab method
to approach this report.
However i found out crosstab method has a lot of restrictions and not a flexible method. Even though my final report fit the requirement, but it will be hard for future request change.
Is there other way i can accomplish the result i want (like crystal_report_result.doc)
I am thinking using sub-report and grouping,
but that will be very complicated.
So please give me some big idea.