https://community.sap.com/t5/application-development-and-automation-discussions/using-an-sql-view-as-a-datasource-with-a-parameter/m-p/12713622#M2019310 <P>I've created a report where the data is coming from an SQL View. It works. However, I need to use a parameter to filter the view down slightly for the report. I created a parameter in the report. The report.SetParameterValue function has no effect and the view returns all records. The code below works except the SetParameterValue line has no effect.</P> <P>Report1 = new Report1();</P> <P>Report1.SetParameterValue("parmInspectionID", m_nInspectionID);</P> <P>CrystalReportViewer.ReportSource = Report1;</P> Tue, 18 Apr 2023 19:57:18 GMT former_member990872 2023-04-18T19:57:18Z https://community.sap.com/t5/application-development-and-automation-discussions/using-an-sql-view-as-a-datasource-with-a-parameter/m-p/12713622#M2019310 <P>I've created a report where the data is coming from an SQL View. It works. However, I need to use a parameter to filter the view down slightly for the report. I created a parameter in the report. The report.SetParameterValue function has no effect and the view returns all records. The code below works except the SetParameterValue line has no effect.</P> <P>Report1 = new Report1();</P> <P>Report1.SetParameterValue("parmInspectionID", m_nInspectionID);</P> <P>CrystalReportViewer.ReportSource = Report1;</P> Tue, 18 Apr 2023 19:57:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-an-sql-view-as-a-datasource-with-a-parameter/m-p/12713622#M2019310 former_member990872 2023-04-18T19:57:18Z