Creating reports and dashboards | Stimulsoft community forum

Hi there,

I have two data sources from different database. One source is from MsSql connection and the other source is from DB2 so a simple join is not possible. The desire report is just a count of all order per customer per product type based on the target date if exist in DB2 otherwise it uses the first order date for the calculation. In addition, the desire report only shows result where the count of the product type 1 is greater than 100, count of product type 2 is greater than 200 and count of product type 3 is greater than 200.

Is this possible to do with Stimulsoft Reports Designer.Web? If so, how? Can you provide a sample?

Thanks in advance!

Desire report link

Hello,

Unfortunately, in this case, with such a data structure (different databases), this report will not be possible to implement in Designer.Web.
To design this report, you must either create a relationship between the tables (but this is not possible when using different databases), or use additional scripts in the events (but they are not supported in Designer.Web).
Alternatively, you can set a connection to the database in the code of your application, create a DataSet and pass it to the report. In such a case it will be possible to create a connection between these tables and use the master-detail scheme in the report and the conditions necessary for you to create the report.

Thank you.