pcsoft.us.windevCopyright 2026, PC SOFT16 Apr 2020 09:11:14 Z11 Apr 2020 18:35:54 ZGood day I am attempting to create an invoice report for a medical practice, and the invoice has several lines - the first shows the consultation carried out by the doctor, the second lines show the treatments given by the doctor, and the third set of lines show the materials used in the treatments. I am relatively new to Windev, and very new to the reporting, and could not work out how to use breaks to print each treatment, together with the materials used, in the correct sequence. I then wrote a union query, which works fine when run on its own and passing the relevant parameter. However, when I select that query when trying to create a report, Windev does not show me the fields returned by the query - it seems I simply cannot use such a query in my report. Has anyone experienced this? I can select the query from the dropdown list of the report in the 'describing the report' section, but when closing that section and re-opening it, my selection is lost. Windev reports simply do not seem to allow one to use a view with a union. If anyone has any suggestions I would be most grateful! Thanks Guy30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67749-query-with-union-not-recognised-report/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)Meredith GUYpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67749-query-with-union-not-recognised-report-67760/read.awp16 Apr 2020 09:11:14 ZThank you Argus and Mike for your replies, much appreciated. I must admit I did not even notice that the Union command was avail…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67749-query-with-union-not-recognised-report-67760/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67749-query-with-union-not-recognised-report-67760/read.awpQuery with UNION not recognised by Reportmikepcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67749-query-with-union-not-recognised-report-67759/read.awp16 Apr 2020 00:07:21 ZIt looks like a nested report will do what you want: https://doc.windev.com/en-US/?1011001&name=nested_reportshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67749-query-with-union-not-recognised-report-67759/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67749-query-with-union-not-recognised-report-67759/read.awpQuery with UNION not recognised by Reporttestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67749-query-with-union-not-recognised-report-67757/read.awp15 Apr 2020 14:15:33 ZAFAIK, -IF- you create your query with the query editor, then it WILL be compatible with the report editor, and EVERYTHING ELSE …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67749-query-with-union-not-recognised-report-67757/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67749-query-with-union-not-recognised-report-67757/read.awpQuery with UNION not recognised by Report