SubReport Help with 2 XLSX sources

Ok, I need help with a simple but important problem. I've built a simple case for understand the problem much better.


I've 2 Excel file:

- Customer data "Customer.xlsx": (ID_Customer, Name, Surname)

-Address data "Address.xlsx": (ID_Address, ID_Customer, Address)


I would built a report that show the customer data and, for each customer, shown the address line (maybe each customer could have 1 or more address). 

So, I've created the main report with the fields Name and Surname in the details area. Under the fields I've created a sub-report component and I've also create the sub-report with the wizard process. So now I've the main report and the sub-report.

If I tried to show the data from each report... 

- From the main report I can see the list of customer but I cant'see anything from the sub-report component.

- From the sub-report I can see the the list of the addresses of the customer.


So I've realized that maybe I can't see the results of sub-report component in Main Report because I've not explicited the relationship between the two reports and what key create the link. So I ask you to describe me what is the problem, because I'm out of mind actually. Thanks so much.


edoardo_1's picture
Joined: Oct 6 2019 - 1:34am
Last seen: 3 years 4 months ago

1 Answer:

Well you should pass the current Field-value $F{ID_Customer} to the SubReport as a so called SubReportParameter with name e.g. "Para_ParentCustomerID" from MainReport at the SubReport-Element.

Inside the SubReport itself you create a Parameter $P{Para_ParentCustomerID} (the same name is important!) and use this within the SubReportQuery. E.g. 

SELECT * FROM Adresses WHERE ID_Customer = $P{Para_ParentCustomerID}

That's all.. then the SubReport should filter out just the matching adress(es) from the current MainReport customer.

hth + regards


C-Box's picture
Joined: Jul 19 2006 - 5:58pm
Last seen: 1 month 2 weeks ago