Grouping in a Subreport

[sondev]

I am currently running Crystal Reports ver. 10.

I have created a subreport that is grouped by 4 fields. I need to include a 5th field and group by TravelRate. My situation is a little rough because when I create the 5th Group for TravelRate, the alignment gets all messed up and I cannot customize the report the way I would like. If I were able to remove Group 4, and Group 3, then the TravelRate would link to the Engineer and the results would list perfectly fine. The only solution I can think of is to create another subreport for TravelRate. Is there anyway to create a formula field where TravelRate will group in the footer of Group 2 w/o disturbing group 3 and 4. Any suggestions?

 

[synapsevampire]

When speaking of data, it's important to include data types.

Providing example data and expected output will help immensely, phrases such as "alignment gets all messed up" and "disturbing group 3 or 4" are neither technical nor very descriptive of the concern.

Please provide example data and the expected output.

Adding groups doesn't alter alignment.

-k