Is it possible to generate desire report in the link below using Stimulsoft Reports Designer.Web?

somegrayhair · Post by **somegrayhair** » Wed May 18, 2011 11:49 am

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

Post by **Andrew** » Thu May 19, 2011 9:16 am

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.