How to make Report for multi table ?

Hi,
If you are using the standard 'report' option within MVD, then any tables that you specify in your report selection are automatically carried across to FastReport;  in the attached example, your 'Customers' table is the equivalent to the 'Departments' table and your 'Orders' table is the equivalent to the 'Employees' table.
Derek.

Hi,
I had a quick look at your project.
What you have is a very straightforward requirement and there is no need for you to use either a script or ReportSQL. 
The main problem is that you data structure is wrong - basically, you do not have any relationships between your tables and it seems you are trying to link them manually using a counter rather than creating relationships in your data schema and letting MVD maintain the links.
Without the correct data structure nothing will work properly, including any reports you want.
Have a look at the attachment.  There are two different approaches you could take for your project, depending on how you want your project to be used. 
a.  FMR1 works at the level of what 'occupation' a celebrity had in a film
b.  FMR2 is more hierarchical - you start with a celebrity (master data) and then go down to the 'occupation' (detail data).
Both FMR1 and FMR2 use the same data schema and the same report but first you must understand your data relationships if you want this (and any other project) to work.  This holds true for ALL relational database software, not just MyVisualDatabase.
Derek.