My Study Group Roster report is not properly including all groups expected.
My GenerateReports form lets you specify which Study Groups and which Portfolios are included in the report. Once all groups and portfolios are chosen, clicking the Generate Report button causes the report to be printed with the chosen parameters.
This is accomplished by saving the selected groups and portfolios in the Selected… tables, and those tables are included in the rqStudyGroupRoster report query.
This query properly returns the expected records including all study groups and all portfolios. You can run the query in design mode to verify the results. If you do this, you need to temporarily edit the query to use your actual UserKey instead of the parameters. Please don’t save the query if you do this!
In any case, the query returns all expected records, but the report only returns the firs 3-4 study groups instead of all study groups. Note: in the GenerateReports form, make sure you select all study groups and all portfolios before clicking the Generate Report button.
I’ve uploaded the latest FDF file to OneDrive. Thanks…