Link to home
Create AccountLog in
Avatar of Mark01
Mark01Flag for United States of America

asked on

Crystal Reports Design - Sorting a Field in a Subreport

User generated imageUser generated imageUser generated imageUser generated imageUser generated imageI'm designing a report that will be used for a financial statement that is very similar to a bank statement.  Each check will be listed in numerical order. The check number and the name of the payee are from a subreport. The main report will list the amount of the cashed check and the date that on which the check was cashed. The source of the data for the main report is from the bank disbursements table. The source of the data for the subreport is from the bank checks table.

There is no repeating data in either report. The problem I have is the current report lists the checks in an unusual order. How do I design the main report and/or subreport so that the checks are listed in numerical order? I'm using an Access 2003 database. Any assistance would be greatly appreciated.

Two report files are attached. "1.rpt" is the main report. "2.rpt" is the subreport.

The following images show the layout of the data in the reports:
Main Report 1a, which is the main report without the subreport ( for"1.rpt"), Main Report 1b, which is the main report with the subreport ( for"1.rpt"), and Subreport, which shows the layout of the subreport (for"2.rpt").

The following images show the report designer table links for the reports:
Links Report 1 (for "1.rpt") and Links Report 2 (for "2.rpt").

The following images shows the subreport link: Subreport Link
1.rpt
2.rpt
All-Pdf.pdf
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Mark01

ASKER

Thank you, mlmcc.