- In Design View, open the main report
- Select the sub report
- Right-click and select Change Sub Report Links
- Select ALL the items in the Field(s) to Link to: window and click on < button
- In the Available Fields window, select CnBio.CnBio_Sortkey (or field being grouped by) and click the > button
- In the Select data in sub report based on field drop-down, change it to CnBio.CnBio_Sortkey (or field being grouped by)
- Click OK
Connect and collaborate with fellow Blackbaud users.