Check out my image:
Basically i need to filter on a piece of data that is in my subreport and I wasn’t sure if that is even possible. Any ideas?
Check out my image:
Ah, good one.
You may make yourself a backup copy, and try copying the subreports DataSet Properties Query expression, and creating a new DataSet and creating output fields, in the main report, from what you copy.
That way, possibly you can then reference the Field that is inside that new DataSet, by fully qualified object name, but from an Expression in your OrderHed DataSet main report. So, thereby setting up a situation where it is just across DataSets instead of Main to Subreport.
In other words, I am not familiar with a way to just reference the fields value directly, you’ve got a shot if you can add the DataSet or perhaps even add another join in the OrderHed DataSet.
It would be really nice if shared variables or just fully qualified naming conventions would work, but I’m not running across anything promising to suggest even trying.
There’s some really experienced resources out here, maybe they’ve tried to cross this bridge before and can be more help to you.
Perhaps if this report was formatted in such a way that the area you wanted was inside the Subreport, then you could pass in the value from the Main report via standard Parameter, into said Subreport.
That makes sense. Make a new dataset from the sub reports dataset and then reference that dataset when im filtering my group. I can give that a shot tomorrow!