Creating reports and dashboards | Stimulsoft community forum

Hi,

I am using Stimulsoft Reports.web. I have a query.
Let's say I have 2 database tables, Table A and Table B I have put a databand called "Databand1" with the datasource as Table A, and then inside "Databand1" i put "Databand2" with the master component as Databand1, the datasource as Table B, and the relation of Table A and Table B.

Till this stage everything is working fine... In my output I can see Table A and Table B data perfectly.

Now I want to add a bit of condition. In my report I want to check if there are 2 values exist in table B for Table A. and print something like "Both Exist" or if only 1 value exist then print "only 1 value exist" etc.

I want my output to be something like this

A_ID Output
1 Both Exist
2 One Exist
3 Both Exist
4 One Exist

Any help will be appreciated.

Thanks,

Ashar

Hello.

You should create a relation between tables, then create a master-detailed report and set a condition to the text component.
Please, look at the attached report template. Thank you.

I clearly had no idea it was going to be this simple.

Thank you very much.

Hello.

We are always glad to help you.
Let us know if you will need any additional help.

Thank you.