pcsoft.us.windevCopyright 2026, PC SOFT2 Jun 2017 07:42:00 Z29 May 2017 14:22:00 ZI am getting rather frustrated with the report generator and I think I need a better approach to the problem. I have a report based on a query and when I test the query it works but when I run the program and pass null for a parameter it always comes up with "No data to print". I have tried passing the parameter as null in iInitReport Query, NOT passing the parameter, setting the parameter beforehand with QRY_ResByPeriod.pnCompanyID = NULL and all return the same result. Is there some other method I should try? Thanks, Garry30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61040-report-problem-passing-null-query/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61040-report-problem-passing-null-query-61090/read.awp2 Jun 2017 07:42:00 ZHi Garry I had this problem a little while ago. Maybe the value Null is seen as a valid value of the field. Check if field…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61040-report-problem-passing-null-query-61090/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61040-report-problem-passing-null-query-61090/read.awpreport problem - passing null to queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61040-report-problem-passing-null-query-61043/read.awp29 May 2017 17:23:00 ZHi Give us some code and we can have a look at it. ;) regards Allardhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61040-report-problem-passing-null-query-61043/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61040-report-problem-passing-null-query-61043/read.awpreport problem - passing null to queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61040-report-problem-passing-null-query-61042/read.awp29 May 2017 15:03:00 ZHi Garry, It depends on how you pass the parameters and how you test the report. In your case with an external query as repo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61040-report-problem-passing-null-query-61042/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61040-report-problem-passing-null-query-61042/read.awpreport problem - passing null to queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61040-report-problem-passing-null-query-61041/read.awp29 May 2017 14:56:00 ZHi Garry, there is no reason why a query would return a different result from inside a report, as long as you are settings it…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61040-report-problem-passing-null-query-61041/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61040-report-problem-passing-null-query-61041/read.awpreport problem - passing null to query