I know adding subreports to an SSRS report in AX is a voodoo art, but at one point in time, I had this working and it has only been since I have made changes to my original report design that it stopped, but from where I sit, I don't think anything significant has changed, so if anyone can see what I'm not, it would be much appreiated.
The scenario: I have a report DP that has four temp tables that it is serving out for this one report. Three of the temp tables are on the main report and for the fourth, we only want to show the values that are in the fourth temp table that match the InventRefTransId that is associated with a particular PmfProdCoBy record. This record populates one of the three temp tables and we need to pass that value to the subreport that is nested inside the tablix that uses that temp table as a data source. In a perfect world I would like to nest a tablix inside the tablix, but when you do that, SSRS forces you to use the parent tablix data set, so that's why we are using a subreport.
Here's the weirdness--if I add the fourth temp table to the main report and create a tablix using it as the data source, the data appears without issue. However, if I attempt to pass the InventRefTransId to the subreport, I get a blank subreport--I was able to confirm this by putting an error message in the "NoRowsMessage" property of the subreport.
I have turned off dynamic filters on the subreport and created a parameter to accept the InventRefTransId value, and at one point in time this subreport worked, but now it doesn't and I am at a loss as to why.
If anyone has any ideas at all as to what I am missing here, I would love to hear them.
Thanks.
Brandt
