Changing the text value of legends (1 Viewer)

johnmerlino

Registered User.
Local time
Today, 04:11
Joined
Oct 14, 2010
Messages
81
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.
 

apr pillai

AWF VIP
Local time
Today, 16:41
Joined
Jan 20, 2005
Messages
735
Change the first Column of the Query as follows:

Code:
SELECT [I][B]Choose(mailer_states.mailer_state,"Sent","Responded","Received") As State[/B][/I],Count(*) As Count FROM mailer_states INNER JOIN mailers ON mailer_states.id = mailers.mailer_states_id GROUP BY mailer_states;
 

Users who are viewing this thread

Top Bottom