When I ran a report in report studio following error occured:
RQP-DEF-0526 QueryReuse: the generated sql is not supported locally.
Using the query for a crosstab/list can give no errors but using the query for a chart gives the error.
1. Go to the Query Explorer
2. Select the query that is used for the chart
3. Under the query properties set Use Local Processing: No