Grouping types in Report

[proballin]

So I have two types of transportation in a report, Bus and Train. I want to have all of my bus information together, then a total and my Train information, then a total and finally a grand total. However no matter how I try grouping I always end up with most of the buses together, then the trains and finally a few buses at the bottom of the report. Any clue as to why this is happening?

 

[dkinley]

Just guessing, but I'd say you are grouping on bus 'types' and not grouping by a 'category' that would simply be 'Bus'.

-dK

 

[proballin]

I apologize for my ignorance but im not sure what you mean exactly. I want it to look like:

Bus
----------------
----------------
----------------
----------------
----------------
Train
----------------
----------------
----------------
----------------

However what I am getting is:

Bus
----------------
----------------
----------------

Train
----------------
----------------
----------------
----------------
Bus

----------------
----------------

In Sorting and Grouping I tried grouping the transportation together as well as when I made the report using the wizard. Nevertheless I get the same results.

 

[dkinley]

This could get lengthy .... is there any way you can post the db?

-dK