Reputation: 37
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:
Upvotes: 0
Views: 62
Reputation: 9101
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}
Upvotes: 2