Creating reports and dashboards | Stimulsoft community forum

Is it possible to combine 2 columns from different data sources and make them match?

For example, if I have a data source with a query that returns daily product sales, and another data source that has all the products that are available to sell, can I drag and drop the product name colum from the products data source, and somehow make it match with the sales from the other data source?

I know I could just add a JOIN to the sales query and get the product name as well, but I want to know if it can be done just by using the GUI

Thanks.

Hello,

Please try to add the relation between these datasources and use the following expression:
DataSourceProducts.RelationName.ColumnNameFromDataSourceSales

Thank you.