Hey
I craete a simple pie chart report, although I have chosen sort by in designer , when I get query back it's something like , which Order by column is ommited, how can I fix it? (I tried same with Bar chart it's same result)
SELECT Count([org].[Organization].[CountryId]) AS [Count of Country id], Count([org].[Organization].[Id]) AS [Count of Id]
FROM [org].[Organization] WITH (READUNCOMMITTED)
ORDER BY
Converting same report to list works fine and this will be the query
SELECT [org].[Organization].[CountryId] AS [Country id], [org].[Organization].[Id] AS [Id]
FROM [org].[Organization] WITH (READUNCOMMITTED)
ORDER BY [org].[Organization].[CountryId]