change x-axis label

This public forum is for user-to-user discussions of ASP Report Maker. Note that this is not support forum.

change x-axis label

Postby bedriakay » Wed Feb 08, 2017 2:58 am

Hi,
I am using ASP Report Maker 9.
I have a table named Sales
I have a field named CityCode like 1,2,3,...80 in this table.
I make sales charts by cities.
on the x-axis values of city like 12,34,55 etc.
x-axis labels for city name 1,2,3,...80 (citycode)

I want to change x-axis label as
if citycode=1 then
cityname = "ISTANBUL" '(x-axis label 1)
else if citycode=80 then
cityname = "ANKARA" '(x-axis label 2)
.................

or i have a city table, it has two fields, citycode and cityname.
Can i use ew_Loadrow function to get cityname from city table for x-axis labels?

How can I change the x-axis label according to the values?
I tried Chart_Rendering Server Events but i can not do it.

regards,
Bedri
bedriakay
 
Posts: 23
Joined: Sun Dec 04, 2016 8:39 pm

Re: change x-axis label

Postby motfs » Wed Feb 08, 2017 1:02 pm

Use the Chart_DataRendered server event to change the "label" attribute. Enable debug mode to show the chartxml (click Tools -> Advanced Settings -> Debug). Read Server Events and Client Scripts -> Chart_DataRendered in help file for more details.

> ew_Loadrow

Use ewr_Loadrow instead.
motfs
 
Posts: 710
Joined: Tue Sep 08, 2015 4:55 pm

Re: change x-axis label

Postby bedriakay » Thu Feb 09, 2017 1:23 am

Hi motfs,
Thanks, it works well.

Regards.
Bedri
bedriakay
 
Posts: 23
Joined: Sun Dec 04, 2016 8:39 pm


Return to General Discussion (ASP Report Maker)