grouping one of the fields into the header

[Mr.K]

I'm just starting to design reports and already ran into the limits of my knowledge, so I hope you can help. I have a Class name as a header and then a detail section that has the following fields: Date of class, Teacher, and other...

I wish my report would show the Class name in the header, then list of dates from the detail section in one row and then the rest in detail section. So, instead of:

ClassName: Module I
-----------------------
01-01-06 TeacherName OtherInfo1
01-02-06 TeacherName OtherInfo2
01-08-06 TeacherName OtherInfo3

i wish to show it like this:

ClassName: Module I
TeacherName
ClassDates: 01-01-06, 01-02-06, 01-08-06
-----------------------

OtherInfo1
OtherInfo2
OtherInfo3

 

[Ziggy1]

Thats a tricky one, what I have done in the past is create a Sub report. I would make a new report (same control source) but make it simply show Teacher and class date. The trick is that you change the page setup to display more columns eg 6. this way the dates will go accross and then down. I think also group by teacher. when you run the report by itself it is not much use, but after you do what I describe below it will break it down

Then on your main report I either use the subform/report wizard, or I "Drag" the new report in to where I want it. You have to link the key fields.

I'm going by memory so i can't remember everything, I'll have to check one of my DB's at work tomorrow.

 

[gemma-the-husky]

the class dates bit is hard. you can use sorting and grouping to get

teacher1

class dates other info
1/1/06 blah blah
1/2/06 blah blah
1/3/06 blah blah


which would be the normal way to do it.

 

[Ziggy1]

hello, I whipped up this example of what I was trying to explain. It isn't pretty , but it will give you a better idea.


oops forgot the attachment...

 

[Mr.K]

Thanks a lot Ziggy1; I finally got back to that report and your solution worked perfect. At first I had some problems (my fault) and tried things like changing the recordsource of the subreport with vba, but was getting errors that source cannot be changed on printpreview. That went back to your solution, noticed my mistake and all worked well.

 

[Ziggy1]

That's great!, Yes I like that method, it has saved me a lot of paper