View Single Post
Old 02-03-2011, 03:28 PM   #1
Newly Registered User
Join Date: Oct 2010
Posts: 81
Thanks: 0
Thanked 0 Times in 0 Posts
johnmerlino is on a distinguished road
Changing the text value of legends

Hey all,

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 = mailers.mailer_states_id GROUP BY mailer_states;

So rather than displaying:

I want to display:

Thanks for response.

johnmerlino is offline   Reply With Quote