Hope all is well,
1) My assignment is to create a student progress report.
(They already have one, created with a 3rd party tool that pulls directly from their Oracle prodcution database. This tool is not able to include the student's photo, so have been asked to create in Access)
2) The data behind this report is a query.
The query pulls the entire table: TBL_transcript, and just sorts it.
I could have pulled directly from the table but it does not have a primary key so is unsorted,
so the query sorts the data.
The reason TBL_transcript does not have a primary key, is bec i have code that
dynamically builds the table. (i guess i could write EE for vba code how to assign a primary
key programatically, but i digress)
The data is pulled from an Oracle data warehouse. (i execute the oracle query using a .bat
file that exports to excel, and then import into access.... this is all done with vba so it's
3) The data is only for one student (when i execute the .bat file, will send the student's id
as a parm)
4) The report groups by semester:
for ex: 2008 Fall
Each semester can have 4 -6 courses under it.
2 semesters make up an academic year:
2008 Fall and 2009 Spring = 2009 Academic Year
Which is why created 2 group bys in the report:
Academic Year Description
Academic Period Description
My issue/challenge with the report:
a) report will have a header with lots of students "fixed fields of info"
b) the body of the report will list student's course history (many rows)
c) need the course info to present as 2 columns
d) Below, have uploaded:
1) test mdb
2) 2 screen shots
e) i set up the report for 2 columns. The data is flowing vertically down.
HOWEVER, am not "spilling into" the second column bec. do not have enough data to go to column 2.
f) would like to group by academic year description and academic period description
g) would like to have 3 groups vertically to the left.
and 3 groups vertically to the right, with a verical line separator.
h) since 2 semesters make up a year, present the semesters horizontally like this
2009 Fall 2010 Spring
Please see SCREEN SHOT 1 (in mdb: rpt_015_Transcript)
h) Is there a way to force the data to go into column 2?
i had a similar problem in the past, and an EE expert i modifed the footer to be larger
i tried that .... the report is close but it has issues, such as
the group by fields are not printing along with the date (i circled in red the issues)
Please see SCREEN SHOT 2 (in mdb: rpt_015b_Transcript)
tx for your help and ideas,