F.Fasser F.Fasser - 22 days ago 6
C# Question

Repeating table in subreport

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.

enter image description here

Here is also a preview of the table:

enter image description here

Answer

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}