When I open the subreport all the data is there.
Under the properties:
All
Name............Grouped by CM Shares
Source Object... Report.qry_Grouped by CM Shares
Link Child Fields.... AssetName
Link Master Field..... AssetName
Visible............... Yes
Can Grow.............. Yes
Can Shrink ........... Yes
Thanks for your help, Rich.