Crosstab help please
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
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
This discussion has been closed.
Comments
"Total" rather than "Sun".
Thanks
Eric
solved a similar issue to this for me
Phillip Herries
running D6 and RB 7.03.
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.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com