Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SubReports - data is not sorting on the report (but the query that is its source is sorting in the right order.....)

Posted on 2011-03-07
2
Medium Priority
?
396 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:mytfein
2 Comments
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 35059237
<<The problem is, that the query IS SORTING CORRECTLY IN START DATE sequence,
     but it's not displaying that way on the report....>>

  Reports ignore any sorting in the underlying query because the report needs to know how things are ordered in order to do its job.

  Set the sort in the reports sorting and grouping properties and you'll be set.

JimD.
0
 

Author Comment

by:mytfein
ID: 35059340
Hi JIm,

that was it.... tx so much, s
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question