I’ve added several Expressions to my container and could Lookup the values in the Report Manager.
When I added a Pass through Variable though, I can no longer Lookup the values? Can I add a Lookup to a Pass Through Variable?
Yes you can, by allowing lookups in the Administrator module.
Method
1. When adding expressions of type Data Field or SQL Expression in the Administrator module, the option to Allow Lookups are allowed by default.
2. When adding a Pass Through Variable though, it is not allowed by default and Report Output will look like below with no option to look up a value:
3. You need to click the checkbox in the Administrator to Allow Lookups
4. Now, when running the report, Lookups will be allowed.
