Hello! I'm having some problems with a subreport/report and hoping someone can help. Here's what I have:
My main report (Report A) uses a view and is grouped by a field called CustomerID. I currently have 2 subreports in the main report (one is linked to Report A by CustomerID and the other by TaxID). Those seem to be working fine.
I have created another report (Report B) using another view along with a different database (however, one of the subreports I mentioned above is also using that same database so I don't think that's the problem). When I run that report the data generates perfectly. Report B is grouped by CustomerID also (the same CustomerID as the one used in Report A).
I place Report B into Report A as a subreport. Without linking things the subreport generates all the data perfectly. But when I link by CustomerID I receive the following:
Failed to Retrieve Data from the Database
Invalid Argument Provided
Thoughts? I've tried to link by other things like CustomerNameFull (this is the same exact field on both reports) but get the same message. Thanks in advance for help!