Crystal reports unlinked sub report with Parameter generates error on main report
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!
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!
WHat version of Crystal are you using?
Is it a stand-alone version or is it an Epicor OEM version?
mlmcc
Is it a stand-alone version or is it an Epicor OEM version?
mlmcc
ASKER
vasto - I am able to run both reports in Epicor, but not once I put the subreport in the report.
How do I link the subreport parameter to the main report parameter?
mlmcc - I have Crystal Reports 2008, and I can use it stand alone, but mostly I access it through Epicor, due to that automatically putting the reports in the desired locations.
How do I link the subreport parameter to the main report parameter?
mlmcc - I have Crystal Reports 2008, and I can use it stand alone, but mostly I access it through Epicor, due to that automatically putting the reports in the desired locations.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I've requested that this question be closed as follows:
Accepted answer: 500 points for mlmcc's comment #a39818474
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Accepted answer: 500 points for mlmcc's comment #a39818474
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
ASKER
With testing, I found this worked.
Also, it is a better practice to define the subreport parameters on main report level and pass them down to the subreport ( by linking the subreport parameter to the main report parameter)