Repeating table in subreport

Question

I have a table in a subreport that pulls from a database. It reads all data correctly, but now I want only the data connected to a specific course. How can I filter the results?

I added the ID of the course as a subreport link. But each ID has its own subreport, and I only want one table to contain all the data.

Here is also a preview of the table:

Answer 1

You shouldn't add the ID as a sub report link instead you should add the ID in record selection formula.

Open the record selection formula and add as:

ID=yourvalue 
//if you want user to priovde value at runtime then add parameter
ID={?Parameter}