Problem in accessing two different data sources in same report


Hi Team,

I am trying to access two different data sources i.e one oracle and other CSV file in same report.

Please suggest me how can I achieve this



monika.sudam.mali's picture
Joined: Feb 26 2019 - 6:44am
Last seen: 1 hour 1 min ago

1 Answer:


You could define a so call "SubDataSource" within your design, where one is for accessing your oracle database via an select (Connection must be passed from Outside, when filling the report) and the second one could access your csv file (filename could be passed as parameter or hardcoded or whatever).

The SubDataSources could be used for SubReports or ListElements or Crosstabs or Tables.....

You could also just use the main datasource (e.g. the sql oracle one) for filling process of the MasterReport and just the CSV-SubDataSource for a integrated SubReport.

So just give it a try.

hth + regards


C-Box's picture
Joined: Jul 19 2006 - 5:58pm
Last seen: 4 min 36 sec ago