pcsoft.us.windevCopyright 2026, PC SOFT18 Jul 2015 00:58:00 Z15 Jul 2015 10:01:00 ZHi I have some complex coding to create a data sources which will change depending on user requirements. I want to create a report outside of the application on this data. ( User can create and modify ). If I can output the data source as an "external" .fic file, then maybe R & Q can use it to create the report. Ie Can I export the data source created via HExecuteSqlQuery into a permanent file. Any comments appreciated30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53070-hexecutesqlquery-data-source-for-reports-amp-queries/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53070-hexecutesqlquery-data-source-for-reports-amp-queries-53124/read.awp18 Jul 2015 00:58:00 ZThanks Paulo for the advice. Have given that a try, but cannot find how to use HDeclare External with runtime R&Q. Will ask the …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53070-hexecutesqlquery-data-source-for-reports-amp-queries-53124/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53070-hexecutesqlquery-data-source-for-reports-amp-queries-53124/read.awpHExecuteSqlQuery to data source for Reports & Queriesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53070-hexecutesqlquery-data-source-for-reports-amp-queries-53087/read.awp16 Jul 2015 11:07:00 Zi never used Reports & Queries but if it works with data sources HDeclareExternal is one possible way.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53070-hexecutesqlquery-data-source-for-reports-amp-queries-53087/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53070-hexecutesqlquery-data-source-for-reports-amp-queries-53087/read.awpHExecuteSqlQuery to data source for Reports & Queriesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53070-hexecutesqlquery-data-source-for-reports-amp-queries-53078/read.awp16 Jul 2015 03:12:00 ZHi I have found that I can use "Create table myTable as Select..." which saves the table perfectly. How ever it seems that…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53070-hexecutesqlquery-data-source-for-reports-amp-queries-53078/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53070-hexecutesqlquery-data-source-for-reports-amp-queries-53078/read.awpHExecuteSqlQuery to data source for Reports & Queries