|
| HExecuteSqlQuery to data source for Reports & Queries |
| Iniciado por guest, 15,jul. 2015 10:01 - 3 respuestas |
| |
| | | |
|
| |
| Publicado el 15,julio 2015 - 10:01 |
Hi
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 appreciated |
| |
| |
| | | |
|
| | |
| |
| Publicado el 16,julio 2015 - 03:12 |
Hi
I have found that I can use "Create table myTable as Select..." which saves the table perfectly.
How ever it seems that Reports & Queries needs the file "Declared" before it can see it.
Now need help to see the file without having to add to the analysis.
Thanks |
| |
| |
| | | |
|
| | |
| |
| Publicado el 16,julio 2015 - 11:07 |
| i never used Reports & Queries but if it works with data sources HDeclareExternal is one possible way. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 18,julio 2015 - 00:58 |
| Thanks Paulo for the advice. Have given that a try, but cannot find how to use HDeclare External with runtime R&Q. Will ask the forum. |
| |
| |
| | | |
|
| | | | |
| | |
|