Creating reports and dashboards | Stimulsoft community forum

Good day, im looking for something than can work like a left join equivalent, I know that the new relation is an inner join equivalent, but cant find a way to get data like a left join would do with a sql query, I cant use sql query in this report. I have 2 tables, table one has items, table 2 has depot stock, some items arent stocked in some depots, but i have to show the item in the depot and show 0 stock, its really easy with a sql query but im asked to make it witout querys, any idea how i can make it?

Hello,

Can you please send us your report with test data which reproduce the issue for analysis.

Thank you.

the report is in a diferent ending than the one that stimulsoft uses, i think with just changing the ending it will work, the database has 4 tables but the report only uses 2 in the moment, im planing to use the 4 tables anyway, the data base is in spanish, "productos" are the items, cidproducto is the id from the items, "almacenes" are the depots, cidalmacen is the id,"ejercicios" is the year and "existenciacosto" is the depots stock, cidexistencia is his id and also have the id from items, depots and the year, i want to show all the items in the report, and the stock in the storeges, but if there arent any info of that item in the depots stock i want it to show 0. i hope you can help me.

Hello,

Please send us a .mrt file and sample how it should look like.

Thank you.

Hi, this is the report im making in mrt file and the way i want to show the data, i dont want it to be an exact copy, just want the data to be right.

Hello,

Can you please clarify by which column table admProductos links with admEjercicios. Please try to add the Relation between these tables and use master-detail construction.

Thank you.

Hi, this image explains how the tables are related. I cant modify the databases.

Hello,

Please try to use the Relations. Your tables have many columns with specific name and it is difficult to understand for us what do you want to show.

Thank you.

Hi, these 2 reports i send are what i have obtained, the one that is called ReportSQL is made with a sql query, it gives me the info i want, the second one is made with the options i have in stimulsoft, but it isnt giving me the information i want, i have tried diferent ways of making it but it this one is the nearest one to the report i want.

Hello,

Unfortunately, it is not possible without using query.
Your query is very complex and it is difficult to realize it in designer.

Thank you.