Crosstab help please

rbuser

I have attached an Excel spreadsheet that holds the data that is returned
from a SQL2000 stored procedure and used to drive a report as well as a
crosstab component. Not sure how long this has been happening because it was
just brought to my attention. The Crosstab groups the data by RouteType and
then by TruckType. So it should look like:

Route Type Truck Type Total
COM FL xxxx.xx
RL xxxx.xx
COM TOTAL xxxx.xx

REC FL xxxx.xx
SL xxxx.xx
REC TOTAL xxxx.xx
...and so on.

Somtimes it runs as expected. However, other times it seems to have a
problem grouping on the route type. It will do a section for each route
type, and then do the same sections over again. I don't think it is
duplicating the data, just not grouping all the data together at the same
time. So it looks like:

Route Type Truck Type Total
COM FL xxxx.xx
RL xxxx.xx
COM TOTAL xxxx.xx

REC FL xxxx.xx
SL xxxx.xx
REC TOTAL xxxx.xx

COM FL xxxx.xx
RL xxxx.xx
COM TOTAL xxxx.xx

REC FL xxxx.xx
SL xxxx.xx
REC TOTAL xxxx.xx

I hope I explained this clearly enough...

Thanks

Eric

rbuser

One note in regards to the attachment, the last column should be labeled
"Total" rather than "Sun".

Thanks

Eric

rbuser

Make sure you and your client are running the latest update i.e. 7.03 as it
solved a similar issue to this for me

Phillip Herries

rbuser

I should have specified my environment. Thank you for the suggestion. I am
running D6 and RB 7.03.

Eric

nicocizik

Hi Eric,

Please send a small example report, perhaps using the DBDEMOS database that
recreates this issue to support@digital-metaphors.com and I'll take a look
at it for you.

--