Help with report

[dubaimuscat]

Hello All,
I have the following data on sql server and I only want stimulsoft to pull the teachers name for report if the reporting ID is 149. I want it to ignore any other reporting period ID


{MainData.TeacherNameForReport} {MainData.ReportingPeriodID}


How do i do this> Thanks for any help

[Lech Kulikowski]

Hello,

You can add filter in your SQL source:
select * from tableName where ID=149

Thank you.