![Avatar of Mark01](https://cdn.experts-exchange.com/images/experts-exchange/avatar-01-large.gif)
Crystal Reports Design - Sorting a Field in a Subreport
![User generated image](https://filedb.experts-exchange.com/incoming/2013/02_w07/635056/SubreportLink.jpg)
![User generated image](https://filedb.experts-exchange.com/incoming/2013/02_w07/635054/Main-Report-1b.jpg)
![User generated image](https://filedb.experts-exchange.com/incoming/2013/02_w07/635053/Main-Report-1a.jpg)
![User generated image](https://filedb.experts-exchange.com/incoming/2013/02_w07/635052/LinksReport2.jpg)
![User generated image](https://filedb.experts-exchange.com/incoming/2013/02_w07/635051/LinksReport1.jpg)
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
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER