I have a table with the following data.
load store door# qty
15 104 100 5000
15 152 56 5000
19 120 23 6000
19 150 55 8000
21 156 23 9000
What I want the report to show is the following:
Load 15 Load 19
store qty store qty
104 5000 120 6000
152 5000 150 8000
It is a little more complicated than that, but that is the jist of it. I want all stores with each corresponding quantity underneath each load. It needs to print 5 across then down. I know how to print across then down in the column settings, but I can't get the format to look like this. Any suggestions are greatly appreciated.
THANKS
Greg
load store door# qty
15 104 100 5000
15 152 56 5000
19 120 23 6000
19 150 55 8000
21 156 23 9000
What I want the report to show is the following:
Load 15 Load 19
store qty store qty
104 5000 120 6000
152 5000 150 8000
It is a little more complicated than that, but that is the jist of it. I want all stores with each corresponding quantity underneath each load. It needs to print 5 across then down. I know how to print across then down in the column settings, but I can't get the format to look like this. Any suggestions are greatly appreciated.
THANKS
Greg