Creating reports and dashboards | Stimulsoft community forum

Hi.
I have a database that contains 2 tables, insurance & paper.
Table insurance instruction:
Insurance_name [type = text, primary key]

Table paper instruction:
Number [type = int, primary key]
Insurance_name [type = text]
Price [type = bigint]

Now I want a report in stimulsoft report that give a result of below query:

“Select count(*) from paper where paper.insurance_name = insurance.insurance_name;”

“Select count(*) from paper where paper.insurance_name = insurance.insurance_name
And price <= 0;”

By these queries I mean search through paper table and find how many insurance_name exist for each insurance name.
Please help me
Thanks

Hello,

Please try to use the master-detail construction. You can find a samples in our Demo.

Thank you.