Date ranges in sub reports
I have a Crystal XI report pulling physician information by type of case (MS-DRG) for 6 months of discharges. The report looks at cases and average length of stay for each physicians top 5 MS-DRGs. I built a sub report to pull cases and average length of stay for ALL OTHER physicians for the same 5 MS-DRGs. The goal is for each physician to be able to benchmark their average length of stay with other physicians in the same hospital. This report will be accessed at the hospitals through Crystal Enterprise InfoView. In InfoView, I can only see one set of filters instead of one for the main report and one for the sub report, so the end-users can't change the sub report select criteria. Therefore, I need the parameters passed from the main report. I can get everything to work except the discharge date range since the link creates and equal link. We store our dates in number fields in the format YYYYMMDD.
How can I get the sub report to run for the same date range as the main report?