How to combine columns of 2 data sources with no SQL code?

Stimulsoft Reports.NET discussion
Post Reply
theregister
Posts: 53
Joined: Wed Nov 27, 2013 5:24 pm

How to combine columns of 2 data sources with no SQL code?

Post by theregister »

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.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: How to combine columns of 2 data sources with no SQL cod

Post by Alex K. »

Hello,

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

Thank you.
Post Reply