Changing the text value of legends
I found it surprisingly difficult to change the text value of legends when creating a chart on a report. I read in another forum that you have to alter Row Source in Property Sheet. The thing is the Row Source just contains a query:
SELECT [mailer_states_id],Count(*) AS [Count] FROM [mailers] GROUP BY [mailer_states_id];
So this does not allow me to alter anything. What I really want to display is text which I could get at something like this:
SELECT mailer_states.mailer_state,Count(*) As Count FROM mailer_states INNER JOIN mailers ON mailer_states.id = mailers.mailer_states_id GROUP BY mailer_states;
So rather than displaying:
I want to display:
Thanks for response.