View Single Post
Old 02-03-2011, 03:28 PM   #1
johnmerlino
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 mailer_states.id = mailers.mailer_states_id GROUP BY mailer_states;

So rather than displaying:
1
2
3

I want to display:
sent
responded
received

Thanks for response.

johnmerlino is offline   Reply With Quote