• Registered: 2018-12-02
  • Posts: 154

Topic: How to create a report from 3 tables?

Three tables are T1,T2.T3.T1 is parent table (having fields F1,F2) and T2,T3 are child tables( both containing fields id_F2).
T2 and T3 have multiple rows with id_F2. Report is needed for a particular value of F2, containing all records from T2 and T3..
Should the report button be in the form saving data to T1?
Will calculated fields in T1 help? Or  SQL query using inner join needed?

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 1,413

Re: How to create a report from 3 tables?

Hi eyeman

The answer to your question depends on how you want to generate the result for the report.
If your result is generated in a table, you simply output the data from the table to the report, the Report button. The table can be hidden.
As a rule, MVD copes quite well with the formation of an SQL query. Calculated fields have to be used in exceptional and unusual cases.
If you want to generate a result without the participation of a table, you use the Report SQL button and write your query using various table joins. Calculated fields will not help you in this case.
The location of the Report button does not depend on the form.

  • Registered: 2018-12-02
  • Posts: 154

Re: How to create a report from 3 tables?

Hello Sparrow,
Thanks for the guidance. The output Report will contain details from multiple tables in multiple tabular form. I shall try the INNER JOIN query and update how it goes.
Regards,
Eyeman

  • From: Philippines
  • Registered: 2018-10-23
  • Posts: 431

Re: How to create a report from 3 tables?

I use UNION in some complex report I'm working on MVD. Very powerful, you just have to plan on what report or dataset you want to feed to fastreport.

brian