x

how to inspect the chart name(any functions)

i have two charts which uses only one dataset both access all the field but i want to differentiate the data to the two charts based on chart name
so can any one tell me how to inspect the chart name and pass a value based on the name to query
like
pass1 when chart name is a
pass 2 when chart name is b....
and retrive the data to exact chart
more ▼

asked Feb 23, 2011 at 03:24 AM in Default

yogi gravatar image

yogi
215 9 10 12

I did not get your point properly. What is meant by "so can any one tell me how to inspect the chart name"? When names to the charts could be provided explicitly. And the flow somehow seems to be opposite to what normally is? OR May be I am bad at understanding the questions :)
Feb 27, 2012 at 10:11 AM Sacred Jewel
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
Can you use the Chart's filter properties to make sure they use the data you want them to?
more ▼

answered Feb 23, 2011 at 04:01 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

i cant go with that in this case as i want to hide the chart if does not have a value if i use chart filters in visibility i cant acess the data used for the chart
Feb 24, 2011 at 08:32 PM yogi
(comments are locked)
10|1200 characters needed characters left
not possible as far as i have seen
more ▼

answered Feb 27, 2012 at 09:38 AM

yogi gravatar image

yogi
215 9 10 12

Is it more than one year since you posted this question? If yes, what was done to overcome it? Anything you want to share why you get the thread live again?
Feb 27, 2012 at 10:20 AM Sacred Jewel
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1846
x558

asked: Feb 23, 2011 at 03:24 AM

Seen: 1041 times

Last Updated: Feb 27, 2012 at 10:20 AM