The solution to this is not as obvious as it might seem. The devil is in the details so they say.
In Crystal X this approach has worked for me.
Follow these steps.
1. Right click subreport and select Subreport links
2. In the left pane (available fields) select your input parameter field and click the right arrow to add it to the right side pane (fields to link to)
3. In the bottom right corner, check the options "Select data in subreport based on field"
4. In the drop down, now select "Report Fields" nothing more.
5. Click OK
6. Go to your subreport and select the record or group filter criteria.
7. You may, or may not see a statement something like this...
"{SO_HEADER.DPT_AUTO_KEY} = {?Pm-DEPARTMENT.DPT_AUTO_KEY}"
in that the parameter field filter was already written for you.... but likely not.
8. however, you should now see your main report parameter field displayed in your "Report Fields" list from which you can choose to filter your sub report data on.
9. Manually write your record or group filter criteria using your newly registered parameter field.
NOTE: Let's think about this. A parameter field is defined by you, so Crystal doesn't really know what could be "linkable" to your parameter field. Instead, you must NOT select any of your tables or table fields but choose the "Report Fields" instead. This will add it to your sub report "Report Fields" list as a parameter from which you can manually write your filter statements,etc.
IP Logged
