Hello,
I am writing a Windows form application in Visual Studio 2012, and have a RDLC report that has a subreport. The main report is based on a Tableadapter, dtLikes, that has three fields: ID (primary key), Name and Likes.
The subreport is based on a Tableadapter, tblInfo, that has 5 fields: ID (primary key), PersonID (which is the link to dtLikes), Address, Phone, and Male. It displays PersonID, Address, and Phone. It has a row group on PersonID.
The subreport has a parameter, ParamPersonID. It also has a filter: [PersonID] = [@ParamPersonID]. The main report assigns ID to ParamPersonID.
When I run the main report with the SQL for dtLikes having a where clause, like where ID = 2, everything works great: the main report shows the appropriate data, and the subreport shows data for that person. The problem is when I remove the where clause, the subreport only shows data for one person. Why doesn't it show data for each person in dtLikes?
Thank you