RBarryYoung how were you able to make a join between cc.Customer_ID and bc.Customer_ID ? cc is inside your subquery and it is not visible outside that query.

Your query should...

there is a work around. Expose metadata that will be flowing though the pipeline in your original Stored Proc. For eg. last statement of your stored proc will be something...

Glad that I could help. 🙂

Sad that Report Builder functionality did not help. :crying: I had same problem back in 2008 when I was trying to find a way to...

Not an expert here but my guess is, InstanceSelection property will come into effect when you pull entire entity (not attrubites from the entity) on the report designer area (in...

This is something that you need to specify in BIDS while creating report model. You need to go to report model select attribute of the entity in the MODEL. Each...