How to select multiple data sources in a report?

Unknown

How to select multiple data sources in a report?

Unknown

Can you walk me through how to pull in multiple data sources in a report? Once I bring in one data source, the other options seem to go away.

Unknown

Reports in Decisions can only handle a single datasource object at a time. This is why the additional datasource objects are hidden when you select one.

However, this doesnt mean that said datasource object can only pull its data from one source. The datasource object that you select when you are building your report can be setup to take in data from multiple sources.

Here are two ways to create a datasource object with multiple sources:

1) Create a flow that pulls all the data from multiple sources and use this flow as the datasource object when you are creating your report.
The flow behavior will need to be set to Reporting Flow in order for this flow to source a report.

Here is a document explaining how to set a flow like this up:

http://documentation.decisions.com/using-flow-source-report/

2) A second option would be to write a custom database query and use this query object to source the report. Once it is created there should be a new report datasource under common > database > [queryname]

Here is a document explaining how to create a custom query:

[url=https://documentation.decisions.com/docs/add-query-external-database]https://documentation.decisions.com/docs/add-query-external-database[/url]

Let us know if you need anymore help with this.
[i]edited by Brendan@decisions.com on 9/23/2019[/i]