F.Fasser
F.Fasser

Reputation: 37

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

Upvotes: 0

Views: 62

Answers (1)

Siva
Siva

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

Related Questions