Hi All,
Totally stumped on this - had the report working but now.....don't know what's changed.........
So a fairly simple report with two subreports - both subreports have their own queries not relating/using anything from the mainreport. One sub report links fine on two master/child fields ie master Vintage;EmpID and Child Vintage;EmpID
The other subreport is quite similar and uses the same tables but not the same query and will NOT link on two master/child fields - it will link on each one separately but not the two together as the other subreport does........using both link fields i get the 'Expression typed incorrectly or too complex' message. I stripped report down and still same result...
FYI have compacted, reimported into clean db, decompiled/recompiled, created new report, done all the things I can think of, checked and triple checked. Only things I can think of is the subreport 'vintage' field is calculated but why would the other subreport work if this was the problem- it has same calculated field........at a loss
Any thoughts for googling, I've run out of ideas....thank you
Rachael
Totally stumped on this - had the report working but now.....don't know what's changed.........
So a fairly simple report with two subreports - both subreports have their own queries not relating/using anything from the mainreport. One sub report links fine on two master/child fields ie master Vintage;EmpID and Child Vintage;EmpID
The other subreport is quite similar and uses the same tables but not the same query and will NOT link on two master/child fields - it will link on each one separately but not the two together as the other subreport does........using both link fields i get the 'Expression typed incorrectly or too complex' message. I stripped report down and still same result...
FYI have compacted, reimported into clean db, decompiled/recompiled, created new report, done all the things I can think of, checked and triple checked. Only things I can think of is the subreport 'vintage' field is calculated but why would the other subreport work if this was the problem- it has same calculated field........at a loss
Any thoughts for googling, I've run out of ideas....thank you
Rachael