different groups, same header

[Mean Dean]

Okay, so I have a numeric variable called "CourseSemester" that corresponds to, shockingly, the semester in which a course is being offered.

1 = Foundation Year (1st Semester)
2 = Foundation Year (2nd Semester)
3 = Concentration Year (1st Semester)
4 = Concentration Year (2nd Semester)
5 = Elective

I'd like a report that is sorted by this variable, and that has page headers that reflect which year -- foundation year, concentration year, or elective -- each class is being offered in.

For example, if the dataset contains courses from both the concentration year/1st semester and the concentration year/2nd semester, I'd like a page header before the concentration year/1st year classes that says "Concentration Year". But I would not like that same "Concentration Year" header to appear again before the concentration year/2nd semester classes.

And, for example, if the dataset contains courses from the concentration year/2nd semester but not the concentration year/1st semester, then I'd like the "Concentration Year" header to appear before those concentration year/2nd semester classes.

So... how?

 

[Alisa]

Seems like you would need a different data structure so that you could have a one to many relationship between "year" and "semester". If you already have that, it should be simple enough to group by year and then by semester . . . If you don't, and you don't want to change your data structure, maybe you could just make an expression field in your header, like =iif([semester]=1,"Whatever Year", etc.) to hardcode it in manually.

 

[Mean Dean]

If I did the latter, though, and there were courses in the dataset from both concentration year/1st semester and concentration year/2nd semester, I would get two "Concentration Year" headers.

Is there a way to get the results I described in the original post without changing my data structure?

 

[Alisa]

Sure, just make a query that groups by year, and then based the report off of that.

 

[Alisa]

Or you could also do the report based on year, and then do a subreport based on semester.