Is it possible to use multiple data sources in a single freehand sql report.
11 April, 2016
I know when I'm in the report builder I can use the advanced sub query option to join data from two different sources, but can I do the same when building a report using freehand sql? I have a csv in one data source and my main view in another. I'd like to join them to report on but can't seem to find a way to do so while using the freehand sql option.
Hi Derek,
no, freehand SQL reports have some limitations that drag and drop reports don't have, and that is one of them. If you must use freehand SQL, did you consider creating 2 freehand SQL views from the different datasources, then you could create a composite view to combine them?
regards,
David
no, freehand SQL reports have some limitations that drag and drop reports don't have, and that is one of them. If you must use freehand SQL, did you consider creating 2 freehand SQL views from the different datasources, then you could create a composite view to combine them?
regards,
David