Morning.
I am wondering if this is possible using the standalone designer.
I have a report already built that I need to insert a subreport into. However, the sub report needs to use a CSV file as its datasource (main report is using SQL Native). The path to this CSV is stored as a STRING in my main report query. So the MainReport has a SQL statement similar to:
Select Field1, Field2, ....'Path to CSV File' as dsCSV From SomeTable
I know need to tell the subreport that the field dsCSV is the path to the file it should use.
Any ideas as to if this is possible (good program so I assume everything is possible) and how it would be done (looking for an example).
Note that I only have the standalone designer.
Thanks,
Brian