This relates to the question here:
Can someone explain the technicals of this approach.
Where is the sql statement going in the report? Are there specific scenarios where this does or doesn't work?
I had previously believed that the drivers used in CR were specifically read only on the selected tables. So this is a new thing for me.