Crystal Reports

Answer 1

If I were you I would make the grouping condition a formula that has your normal logic and an OR to check for your special logic

Answer 2

Using sub-groups might be what you are looking for. Our application uses Crystal to generate statements, and we have several groupings so we can separate and total at different levels:

• Group 1 is customer (for running batches).
• Group 2 is the disputed status (so disputed charges or bad payments are listed separately).
• Group 3 is the transactions (charges and payments).
• Group 4 is the line-items on individual purchases or refunds.

We use the grouping summaries to list sub-totals under each sale and total balance for each customer.

If you are using one group for Date, Account, and Asset, try adding a new group (menu Insert --> Group) and pick Amount as the grouped by. Crystal keeps the details section intact. You can then add extra space at the end of each Amount group, or insert group-sub-totals (right-click a field and from the pop-up pick Insert --> Summary ) as you need. Crystal allows at least five grouping levels.

Answer 3

Unless I am missing something it looks like you simply need to change your grouping order from:

Date, Account, Asset, Amount, Type

to:

Date, Account, Asset, Type, Amount

So the answer would be to add a group by Amount and Type since you said that it is already grouped by Date, Account, and Asset.

Hope this helps.