chart label mapping to strings

How can I convert chart axis labels to strings. For example instead of
showing 1, 2, 3.. on x axis, how can I show gold, silver etc? Thanks.You can either add a CASE statement to the SQL query and use that for
your label field, or you can add a calculated field to the dataset.
-Josh
bhanoji wrote:
> How can I convert chart axis labels to strings. For example instead of
> showing 1, 2, 3.. on x axis, how can I show gold, silver etc? Thanks.|||I can't create a case statement for label field because if the value is 1 I
say gold and 2 will be silver etc. However if the data is 1.5 I can't map
that to a string. Thanks.
"Josh" wrote:
> You can either add a CASE statement to the SQL query and use that for
> your label field, or you can add a calculated field to the dataset.
> -Josh
> bhanoji wrote:
> > How can I convert chart axis labels to strings. For example instead of
> > showing 1, 2, 3.. on x axis, how can I show gold, silver etc? Thanks.
>|||What do you want it to display if the value is 1.5? Nothing? The actual
value?
-Josh
bhanoji wrote:
> I can't create a case statement for label field because if the value is 1 I
> say gold and 2 will be silver etc. However if the data is 1.5 I can't map
> that to a string. Thanks.
> "Josh" wrote:
> >
> > You can either add a CASE statement to the SQL query and use that for
> > your label field, or you can add a calculated field to the dataset.
> >
> > -Josh
> >
> > bhanoji wrote:
> > > How can I convert chart axis labels to strings. For example instead of
> > > showing 1, 2, 3.. on x axis, how can I show gold, silver etc? Thanks.
> >
> >|||I have the following data
City Speakers
A 8
B 15
C 3
D 7
The graph is showing A, B, C, D on X axis and 5, 10, 15 on Y axis as major
interval is 5. How can I show Bronze, Silver, Gold instead of Y axis labels
5, 10, 15.
Thanks Josh.
"Josh" wrote:
> What do you want it to display if the value is 1.5? Nothing? The actual
> value?
> -Josh
>
> bhanoji wrote:
> > I can't create a case statement for label field because if the value is 1 I
> > say gold and 2 will be silver etc. However if the data is 1.5 I can't map
> > that to a string. Thanks.
> >
> > "Josh" wrote:
> >
> > >
> > > You can either add a CASE statement to the SQL query and use that for
> > > your label field, or you can add a calculated field to the dataset.
> > >
> > > -Josh
> > >
> > > bhanoji wrote:
> > > > How can I convert chart axis labels to strings. For example instead of
> > > > showing 1, 2, 3.. on x axis, how can I show gold, silver etc? Thanks.
> > >
> > >
>|||I found another thread that discusses this. Check it out at:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/1a7ac279edf86082/c8207d4c72f15e26?lnk=st&q=%22values+on+y-axis%22&rnum=1#c8207d4c72f15e26
-Josh
bhanoji wrote:
> I have the following data
> City Speakers
> A 8
> B 15
> C 3
> D 7
> The graph is showing A, B, C, D on X axis and 5, 10, 15 on Y axis as major
> interval is 5. How can I show Bronze, Silver, Gold instead of Y axis labels
> 5, 10, 15.
> Thanks Josh.
>
> "Josh" wrote:
> >
> > What do you want it to display if the value is 1.5? Nothing? The actual
> > value?
> >
> > -Josh
> >
> >
> > bhanoji wrote:
> > > I can't create a case statement for label field because if the value is 1 I
> > > say gold and 2 will be silver etc. However if the data is 1.5 I can't map
> > > that to a string. Thanks.
> > >
> > > "Josh" wrote:
> > >
> > > >
> > > > You can either add a CASE statement to the SQL query and use that for
> > > > your label field, or you can add a calculated field to the dataset.
> > > >
> > > > -Josh
> > > >
> > > > bhanoji wrote:
> > > > > How can I convert chart axis labels to strings. For example instead of
> > > > > showing 1, 2, 3.. on x axis, how can I show gold, silver etc? Thanks.
> > > >
> > > >
> >
> >|||In Y axis tab of the chart, I checked show label and tried to put an
expression in the format code box.
expression in formatcode does not work. expression
"=iif(fields!abc.value=10, "gold",
iif(fields!abc.value=20, "bronze", "silver"))" generates the following error
Report item expressions can only refer to fields within the current data
scope or,
if inside an aggregate, the specified data set scope. Thanks.
"Josh" wrote:
> I found another thread that discusses this. Check it out at:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/1a7ac279edf86082/c8207d4c72f15e26?lnk=st&q=%22values+on+y-axis%22&rnum=1#c8207d4c72f15e26
> -Josh
>
> bhanoji wrote:
> > I have the following data
> > City Speakers
> > A 8
> > B 15
> > C 3
> > D 7
> >
> > The graph is showing A, B, C, D on X axis and 5, 10, 15 on Y axis as major
> > interval is 5. How can I show Bronze, Silver, Gold instead of Y axis labels
> > 5, 10, 15.
> >
> > Thanks Josh.
> >
> >
> >
> > "Josh" wrote:
> >
> > >
> > > What do you want it to display if the value is 1.5? Nothing? The actual
> > > value?
> > >
> > > -Josh
> > >
> > >
> > > bhanoji wrote:
> > > > I can't create a case statement for label field because if the value is 1 I
> > > > say gold and 2 will be silver etc. However if the data is 1.5 I can't map
> > > > that to a string. Thanks.
> > > >
> > > > "Josh" wrote:
> > > >
> > > > >
> > > > > You can either add a CASE statement to the SQL query and use that for
> > > > > your label field, or you can add a calculated field to the dataset.
> > > > >
> > > > > -Josh
> > > > >
> > > > > bhanoji wrote:
> > > > > > How can I convert chart axis labels to strings. For example instead of
> > > > > > showing 1, 2, 3.. on x axis, how can I show gold, silver etc? Thanks.
> > > > >
> > > > >
> > >
> > >
>