Select Report Data Source

I’m wanting to know if it’s possible to select the data source within a report based upon a parameter.

Basically I want to run one select statment if parameter equlas 1 and a different select statement if parameter equals 2.

I don’t think there is a direct way determine data sources based on parameters right now. There are ways to get a similar end result, like using keychain expressions within the report to load data from query 1 or 2 depending on the state of the parameter, or using a conditional statement in a single sql datasource that depends on the parameter (of the Datebase is the same). Depending on the goal, it may be easier to have two copies of the report with the different queries, but that may not suit your use case.