pcsoft.us.windevCopyright 2026, PC SOFT27 Nov 2016 16:26:00 Z26 Nov 2016 15:41:00 ZApologies, this is probably a simple question, but I have searched the help and tried different things and can't work it out. I am building a Data Source from a query that is built from user prompts in a window. dsReport is Data Source sqlCommand is string // Build sqlCommand from user input HExecuteSQLQuery(dsReport,sqlCommand) iPintReport(reportName) // now I want to design the report to run here I want to design a report based upon that data source, but since it does not exist when I am in the report designer how can I link the items to individual fields in the data source? Gary30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable-60513/read.awp27 Nov 2016 16:26:00 Z"You don't mention the version you are running but persistent views exist as materialized views in V20 - not sure when they were…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable-60513/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable-60513/read.awpReport from Data Source variableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable-60507/read.awp26 Nov 2016 23:58:00 ZHello Gary You don't mention the version you are running but persistent views exist as materialized views in V20 - not sure w…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable-60507/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable-60507/read.awpReport from Data Source variableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable-60506/read.awp26 Nov 2016 19:03:00 ZHi Fabrice, Problem is that the data is held in a legacy application and data is FoxPro 9 format. We are trying to avoid w…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable-60506/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable-60506/read.awpReport from Data Source variableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable-60505/read.awp26 Nov 2016 16:11:00 ZHi Gary if you want to link stuff, it has to exist. So my advice is to use the query editor instead, it's very easy. Instead…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable-60505/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable-60505/read.awpReport from Data Source variableguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable-60504/read.awp26 Nov 2016 16:01:00 ZHi Gary if you want to link stuff, it has to exist. So my advice is to use the query editor instead, it's very easy. Instead…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable-60504/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60503-report-from-data-source-variable-60504/read.awpReport from Data Source variable