I am newbie in Crystal report. I stuck into a design problem of crystal report. I would like to design a report as per the desired-report.png (attached).
My dataset is like report2.xml and relationship specified in relationship-diagram.png (attached)
The problem is crystal report make the Cartesian product of these two table which result in several rows. I am using .Net windows application to build this report.
Could anyone please suggest how to design this type of report ?
Could anyone please help ?