pcsoft.us.windevCopyright 2026, PC SOFT3 Jan 2015 22:16:00 Z3 Jan 2015 17:24:00 ZHi - I pass a variable to a report like this: PROCEDURE RPT_BirthdayNote(grpar_Month, grpar_Header, grpar_Message, grpar_Image) Then I try to use it in a SQL statement like this: grsSql is string = [ SELECT * FROM gpsdContacts WHERE bActiveMembershipFlag = 1 AND WL.DateToString(dDOB,'MMMM') = grpar_Month ] HExecuteSQLQuery(grsdDataSource,grsSql) And the Execute fails, says it doesn't recognize the grpar_Month variable. What is the correct syntax for this?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize-49699/read.awp3 Jan 2015 22:16:00 ZHi, I use queries in reports quite extensively and implement them as per Allard's description.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize-49699/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize-49699/read.awpWB19 - passing variable to report - SQl doesn't recognize itguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize-49698/read.awp3 Jan 2015 21:45:00 ZThanks David - I knew that! Just haven't used it enough to keep it in memory. Thanks! Jhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize-49698/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize-49698/read.awpWB19 - passing variable to report - SQl doesn't recognize itguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize-49694/read.awp3 Jan 2015 21:26:00 ZHi and thank you Allard - I have to use SQl b/c I'm not using an Analysis - I've created a bunch of Data Sources so I don't n…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize-49694/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize-49694/read.awpWB19 - passing variable to report - SQl doesn't recognize itguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize-49693/read.awp3 Jan 2015 19:34:00 ZHi Joel WL.DateToString(dDOB,'MMMM') = '%1' ] grsSQL = StringBuild(grsSQL,grpar_Month) HExecuteSQLQuery(grsdDataSource,grsSql) …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize-49693/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize-49693/read.awpWB19 - passing variable to report - SQl doesn't recognize itguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize-49692/read.awp3 Jan 2015 19:02:00 ZHi, you can use sql in reports i guess but I never do that. I create the query. Make it availeble for reports and queries. A…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize-49692/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49687-wb19-passing-variable-report-sql-doesn-recognize-49692/read.awpWB19 - passing variable to report - SQl doesn't recognize it