I have a report that is based off of a union query that has some crosstab queries in it. This report runs fine, no problems. I would like to be able to drop this report into another report as a sub-report and have it filter based on one of the parent reports fields. For the life of me I can't get it to work. I have tried to use the field as a criteria in the union query but get the error that the Jet Engine doesn't recognize that field. I have tried to set the filter property of the sub-report to
- [SupplyingDeliveryPlants] = " & [Reports]![rptPlantSummary]![PlantNumber] & "
but nothing matches that filter. I have tried to link the child and master fields but I get an error that I cant use a pass-through or crosstab query as the source for a sub-report.
The closest that I have come is to set the filter in the sub-report to an actual plant number, i.e. not dynamically filter it with a variable like
- [SupplyingDeliveryPlants] = "20740"
Any help would be much appreciated and I can further explain myself, as I have probably done a mediocre job of it thus far.
Blake