Crystal reports unlinked sub report with Parameter generates error on main report
Posted on 2014-01-28
I don't know if what I'm trying to do is even possible. I'm fairly new at Crystal, and am using Crystal in conjunction with Epicor.
I have a sub report that I want to print on a main report. The two reports have nothing in common. The main report is grouped on three fields, and the data appears in the group footer #3. The records are selected based on an option field's input.
The sub report is grouped on one field, and the data appears in that group footer. The subreport requests a Job Number parameter, which will return the appropriate material information for that job. There is a record selection formula that includes the parameter.
I want this to print in the group footer #3 for the main report (like a continuation of the grouped data). The sub report works perfectly on its own. The main report works perfectly on its own.
When I put the sub report in the main report, and test the report, I put in the main report option (a shipper number). Then the request for the parameter input pops up, and I put in the Job Number, and then I get an error message telling me that there is an error in the record selection formula because the field name is not known.
First, is what I'm trying to do even possible?
If it is, I'd truly appreciate any direction. I have been fussing with this off and on for weeks, and I am clearly spinning my wheels.
Thanks in advance!