Problems wich subreports

[fabiobarreto10]

Gentlemen,

I have a table "company" with a one to many relationship with the table "Product". The table "Product" has
a ratio of one to many tables with the "Steps" and "Notes." I have a report with three subreports,
(1. With the product name and company. 2. Steps and 3. The comments.) In each
one of the master field is the "ProductID" field and also the son "ProductID". After choosing a product shows a button
clicking it opens the report in accordance with the chosen products. (picture1).

I'm trying to choose a company that when open the same report with all products. But that the steps become
and the separate observations, like the image that I built. (picture2)

Thanks for helping.

 

[vbaInet]

I don't understand what you've explained. Can you explain with some examples.

 

[fabiobarreto10]

vbaInet thanks for replying and helping.

I am sending the db again with some modifications to better explain. Please open the form (fFilters) in combo
Analyst choose "David" and then in the combo "Company" choose "IBM", will show a button labeled "Briefing"
click it to open a report with 5 subreports, according to the chosen company.

I'm trying to get out of each product
separately, as in the model Doc.

Thank you.

 

[vbaInet]

You will need to Group By Product ID. So it's either you add the other subreports inside the Products subreport and Group By Product ID in that subreport. Or you display the Products in the main report and Group By Product ID.

 

[fabiobarreto10]

Thank you. I partially understand what you told me. I think I walked a bit by putting a sub in the other.
(bd attached)

But still not coming out perfectly.

Could you tell me otherwise?

Thank you.

 

[vbaInet]

So can you tell me where exactly is off?

 

[fabiobarreto10]

Friend, I managed to solve. Thank you for your help.

 

[vbaInet]

Glad to hear fabio.