Creating reports and dashboards | Stimulsoft community forum

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

Hello,

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

Thank you.