Table form report results??

[PQTIII]

Is there a way to load the results from a report into a table for other sorting purposes? Or can you sort the data after the report runs. I have this routine where the details are read and it compares the a current record to a previous one. I'm trying to determine cycle times for Haul Trucks for each Shovel. The truck has to return to the same shovel each time to measure a cycle time. So if it doesn't return to the same shovel the record is not used. I have to sort on truck by a field that measures seconds into a shift at which the truck get to the shovel. This keeps the loading time for each truck in a time sequence. These trucks can go to different shovel at any time. That is why I only keep the records when the current shovel location for a truck matches previous shovel location for that same truck. A cycle equals a truck leaving a shovel loaded, dumping the load at stockpile, and returning to the same shovel.

Thanks Paul

 

[synapsevampire]

You can export reports to a table of a unique name each time.

I would suggest that you stick with supplying technical information rather than text descriptions:

Crystal version
database/connectivity used
example data
expected output

Based on what you've posted, you are probably better served requesting architectural suggestions rather than suggesting sorttions or writing to tables.

This sort of thing might be readily handled by the database, rather than within Crystal, but this depends upon versions and whether you've permission to build objects in the database.

Another less desirable approach might be using subreports.

Again, technical information is key.

-k

 

[PQTIII]

k

I'm open to any suggestions. I was thrown into this job with zero experience/training. I'm the only one out of 1200 employees using Crystals 9. So there is no one here to help me and half the time what you guys talk about it way over my head. So I'm sorry if I don't explain it very well. I'm learning a little at a time. So the simplist way for beginner like me would be the best!

Thanks Paul