mytfein
asked on
SubReports - data is not sorting on the report (but the query that is its source is sorting in the right order.....)
Hi EE,
My assignment is to print a student's progress report (like a report card).
The parent report has fixed fields of student profile info in the header section.
To "imitate" a 2 column report, the detail section consists of 2 subreports.
SubReport1 is column 1 - shows fall semesters by filtering for ColumnCode = 1
SubReport2 is column 2 - shows spring semesters by filtering for ColumnCode = 2
The parent report's query is a DISTINCT on the fixed fields from TBL_Transcript.
The sub report's query is a does not have a condition in the query for the column code, instead am doing the filter on the column code in the report level.
(Really would like to pass the column code to the query, but i do not know how...
usually i hard code the record source with sql and know how to code sql, but would like to learn how to control
canned queries w/o writing sql.... but i digress)
The problem is, that the query IS SORTING CORRECTLY IN START DATE sequence,
but it's not displaying that way on the report....
uploaded mdb below....
tx for your ideas and advice, sandra
2011-03-07-EE-ARG-14-Transcript-.zip
My assignment is to print a student's progress report (like a report card).
The parent report has fixed fields of student profile info in the header section.
To "imitate" a 2 column report, the detail section consists of 2 subreports.
SubReport1 is column 1 - shows fall semesters by filtering for ColumnCode = 1
SubReport2 is column 2 - shows spring semesters by filtering for ColumnCode = 2
The parent report's query is a DISTINCT on the fixed fields from TBL_Transcript.
The sub report's query is a does not have a condition in the query for the column code, instead am doing the filter on the column code in the report level.
(Really would like to pass the column code to the query, but i do not know how...
usually i hard code the record source with sql and know how to code sql, but would like to learn how to control
canned queries w/o writing sql.... but i digress)
The problem is, that the query IS SORTING CORRECTLY IN START DATE sequence,
but it's not displaying that way on the report....
uploaded mdb below....
tx for your ideas and advice, sandra
2011-03-07-EE-ARG-14-Transcript-.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
that was it.... tx so much, s