Join field in subreport doesn't work

[ailyn]

I was making a report where a subreport is supposed to show the details of the order (because there is more than one). The problem is when I try to join them both on orderId & orderdetial.orderId They don't work. It works for the form so I know I'm doing it right and they are Related as they should by Ids. Why isn't it working? Do subreports need something else?

[geekgirlau]

Nope, the process is the same - have you checked for typos etc? If in doubt, use the builder button (...) which will allow you to select the field names rather than typing them in.

[ailyn]

yes, I did it with the (...) builder and all the same. I'll start it all over again and see what happens.

[geekgirlau]

How did you go with this ailyn?

[ailyn]

Sorry for not closing the post I was busy with other problems as you very well can see by my posts. Now it turns out that the problem was not the report. I've made with the builder a new one with the same tables (proforma joined by orderid, order joined by sellerid & customerid, customer and seller) and it doesn't work at all. I mean the builder works all right and there are no errors but when I click on view it simply doesn't work, it doesn't show anything, ... Oh! I found out why, for some reason if there is no customerid filled in and I ask for the customer fields to show on the report it doesn't show anything.

[ailyn]

Now everything shows but the subrepport shows the same record twice and a Sum I made with the prices from the subrepport on the main repport only gets one of the prices instead of summing them: =(([Subrapport Order Details].Report!Price)+Nz([Subrapport Order Details].Report!Extras)) Well that sum was the reason why I started with the subrepports in the first place so if it doesn't work...