ordering by date in a subreport

  • Thread starter Thread starter Debbie S.
  • Start date Start date
D

Debbie S.

I have subform which also functions as a subreport in one of my reports. Both
the subform and the subreport have three fields: action, taken by, date. In
the subform, I can order the actions by the date simply by placing my cursor
in the date field and right clicking on sort ascending. Now, when I go to any
record in the subform, the actions are all in the correct order by date,
ascending. However, when I go into the report in which I have put the subform
as a subreport, the dates do not list in order. The sorting and grouping in
the report applies only to the main report, not the subreport; and I don't
see any place to be put an order by clause. Does anyone know:

1) Why the dates would be out of order in the subreport even though they are
in order in the subform (same data, from the same query).

2) How to make the dates in the subreport appear in order

Thank you,
Debbie
 
Debbie said:
I have subform which also functions as a subreport in one of my reports. Both
the subform and the subreport have three fields: action, taken by, date. In
the subform, I can order the actions by the date simply by placing my cursor
in the date field and right clicking on sort ascending. Now, when I go to any
record in the subform, the actions are all in the correct order by date,
ascending. However, when I go into the report in which I have put the subform
as a subreport, the dates do not list in order. The sorting and grouping in
the report applies only to the main report, not the subreport; and I don't
see any place to be put an order by clause. Does anyone know:

1) Why the dates would be out of order in the subreport even though they are
in order in the subform (same data, from the same query).

2) How to make the dates in the subreport appear in order
Click to expand...


The form's (temporary) sorting is not carried over. I
recommend that you use a real report for the subreport
instead of using a form as a subreport.

Sorting and grouping is the only reliable way to sort a
report.
 
Back
Top