Multiple columns with subreport.

[Brian]

I've searched the newsgroups, and tried all the obvious suggestions in
multiple combinations of them. Maybe what I want isn't possible.
Here is what I want:
I want data to go across, then down. Let me try to explain what I do
and it may help. I'm making a schedule for classes that we train. I
can get everything to go fine in a single-column environment, but I
want multiple. Here's a sample of what I want. (the numbers represent
the amount of people being trained from the region)

Column1-----------------Column2---------------Column3
4/5/03 4/6/03 4/7/03
2-Reg.1 4-Reg.1 3-Reg.1
4-Reg.3 3-Reg.3 2-Reg.5
2-Reg.9 6-Reg.9 4-Reg.9

I want the columns to read like this because it's easier to look at
than vertical columns. I understand the concepts in reports. The
data in the "Detail" section is repeated until it runs out. If I make
a regular report from this, and make it across-then-down, all of the
data is strung out left to right, not readable. When I leave it as a
single column, and make it a subreport inside the detail section of
another report, it gets better. It just won't span columns. Now, if
I tell it down-then-across, it will span 3 columns, but I'm back to
reading my data in a vertical fashion. If I tell it across-then-down,
it sticks to one column. I've tried playing with the with of the
subreport control, the main report width. Something just isn't
working. Please help.
Thanks.
Brian

 

[Fons Ponsioen]

I would recommend using a crostab querry:
I called the table "course schedule", the amount of people
as Qty, than a date as SchedDate and Region
TRANSFORM Sum([Course Schedule].Qty) AS SumOfQty
SELECT [Course Schedule].Region, Sum([Course
Schedule].Qty) AS [Total Of Qty]
FROM [Course Schedule]
GROUP BY [Course Schedule].Region
PIVOT [Course Schedule].SchedDate;
I think this could work except it lists the region to the
left (row headers).
You can add something like limiting the query to the last
4 or 5 dates etc.
Hope this helps
Fons

 

[Evi]

If you don't want to use a crosstab, could you group the report first by the
date field and give the date field a group footer? The Details section still
has Region and Trainee Count next to each other.

Click on the Footer of the Datefield and in the Properties box, next to
Force New Row or Column choose After Section. Now set your columns in page
setup choosing Down then Across.
Evi