How to customize display report using crystal report

Question

Target Output

In my crystal report I want to display like this. In my query the vehicleplateno there are the same value but in my crystal report it repeats the value.

What I need in my current output are

1. How can I group the same Plate no? the purple circle
2. and also how to compute the amount of the same vehicleplateno. the red circle

My output

Crystal report

How can I align this? the Plate No. and Vehicle is in groupheadersection andthe VMR No. and Amount is in the section3(details) in crystal report designer. My current output output design viewer

Answer 1

Go to Report > Group Expert. Then Select the first field that you want to use to group data. Click the arrow button that's pointing toward the Group By section to move it to that section as shown below.

Then click OK. Refer this too Crystal report grouping