Jump to content
Software FX Community

expressions for max/min on axis


User (Legacy)

Recommended Posts

Reporting Services 2005 has the ability to use expressions for the Max and 

Min of an axis. They haven't made that obvious but I found it on

Microsoft's Support page.

It doesn't seem possible to do that with chartFX. It expects the value to

be a double, but I want to tell it to have a max no greater than my biggest

value.

Is this possible? If so, what's the trick?

-Lori

Link to comment
Share on other sites

Reporting Services 2005 has the ability to use expressions for the Max and 

Min of an axis. They haven't made that obvious but I found it on

Microsoft's Support page.

It doesn't seem possible to do that with chartFX. It expects the value to

be a double, but I want to tell it to have a max no greater than my biggest

value.

Is this possible? If so, what's the trick?

-Lori

Link to comment
Share on other sites

It seems that Microsoft fixed this issue in Reporting Services 2005.  But 

they didn't add the little "Expression" box, so that you would know that you

could put in an expression.

In Microsoft Reporting Services, here's the expression:

example:

In the min box, type

=min(Fields!<column name>.Value)

My issue is that I have data that most of the time will fall between 98 and

100%. If I set min/max to 98/100 respectively, that works ok. But what if

the data goes to 92%. The min won't change. If I had left the min as auto

(using chart fx), it would automatically make the scale 1 to 100. But then

that looks weird when all the data is between 98 and 100.

This needs to be changed to allow expressions.

-Lori

"SoftwareFX Support" <noreply@softwarefx.com> wrote in message

news:ecvLfV3UGHA.3544@webserver3.softwarefx.com...

> By default the Max value is calculated based on the data passed to the

> chart.

>

> How where you setting the Max before, what was the "trick" ?

>

> --

> Francisco Padron

> www.chartfx.com

>

Link to comment
Share on other sites

It seems that Microsoft fixed this issue in Reporting Services 2005.  But 

they didn't add the little "Expression" box, so that you would know that you

could put in an expression.

In Microsoft Reporting Services, here's the expression:

example:

In the min box, type

=min(Fields!<column name>.Value)

My issue is that I have data that most of the time will fall between 98 and

100%. If I set min/max to 98/100 respectively, that works ok. But what if

the data goes to 92%. The min won't change. If I had left the min as auto

(using chart fx), it would automatically make the scale 1 to 100. But then

that looks weird when all the data is between 98 and 100.

This needs to be changed to allow expressions.

-Lori

"SoftwareFX Support" <noreply@softwarefx.com> wrote in message

news:ecvLfV3UGHA.3544@webserver3.softwarefx.com...

> By default the Max value is calculated based on the data passed to the

> chart.

>

> How where you setting the Max before, what was the "trick" ?

>

> --

> Francisco Padron

> www.chartfx.com

>

Link to comment
Share on other sites

That's still not quite working, and definitely wouldn't work if I don't want 

the most max value to be whatever auto thought it was (currently 100%).

Below is what I am trying to achieve, and what my current settings are. I

know have no y-axis values showing.

Information:

a) the values used as y-axis are retrieved from db as decimals (they can

be changed to floats if needed). Anywhere from .00 to .999999

B) have the y-axis values represented as percentages. So if value was

.85, show as 85%

c) only show y-axis values between 100% and the smallest value obtained

from db.

Currently my settings are (for the Y-axis):

AutoScroll false (what is this?)

customgridlines (collectio)

firstLabel 0

ForceZero False

LabelsFormat

CustomFormat

Decimals 0

Format Percentage

LabelValue 1 (what is this too?)

LogBase 0

Max Auto

Min Auto

MinorStep 0

Notify False (what is this?)

Position

ScaleUnit 1

Staggered False

Step 0

Visible True

"SoftwareFX Support" <noreply@softwarefx.com> wrote in message

news:h1Q$cUBVGHA.3544@webserver3.softwarefx.com...

> Simply set:

>

> AxisY.ForceZero = false in the property grid.

>

> --

> Francisco Padron

> www.chartfx.com

>

Link to comment
Share on other sites

That's still not quite working, and definitely wouldn't work if I don't want 

the most max value to be whatever auto thought it was (currently 100%).

Below is what I am trying to achieve, and what my current settings are. I

know have no y-axis values showing.

Information:

a) the values used as y-axis are retrieved from db as decimals (they can

be changed to floats if needed). Anywhere from .00 to .999999

B) have the y-axis values represented as percentages. So if value was

.85, show as 85%

c) only show y-axis values between 100% and the smallest value obtained

from db.

Currently my settings are (for the Y-axis):

AutoScroll false (what is this?)

customgridlines (collectio)

firstLabel 0

ForceZero False

LabelsFormat

CustomFormat

Decimals 0

Format Percentage

LabelValue 1 (what is this too?)

LogBase 0

Max Auto

Min Auto

MinorStep 0

Notify False (what is this?)

Position

ScaleUnit 1

Staggered False

Step 0

Visible True

"SoftwareFX Support" <noreply@softwarefx.com> wrote in message

news:h1Q$cUBVGHA.3544@webserver3.softwarefx.com...

> Simply set:

>

> AxisY.ForceZero = false in the property grid.

>

> --

> Francisco Padron

> www.chartfx.com

>

Link to comment
Share on other sites

The y-values don't show up.  I think this is because the min can be 99.99999 

and the max is 100%.

There are no y-values showing up.

-Lori

"Lori Adams" <ladams@cloudmark.com> wrote in message

news:C3a7mgDVGHA.3544@webserver3.softwarefx.com...

> That's still not quite working, and definitely wouldn't work if I don't

> want the most max value to be whatever auto thought it was (currently

> 100%).

>

>

> Below is what I am trying to achieve, and what my current settings are. I

> know have no y-axis values showing.

> Information:

> a) the values used as y-axis are retrieved from db as decimals (they

> can be changed to floats if needed). Anywhere from .00 to .999999

> B) have the y-axis values represented as percentages. So if value was

> .85, show as 85%

> c) only show y-axis values between 100% and the smallest value obtained

> from db.

>

> Currently my settings are (for the Y-axis):

> AutoScroll false (what is this?)

> customgridlines (collectio)

> firstLabel 0

> ForceZero False

> LabelsFormat

> CustomFormat

> Decimals 0

> Format Percentage

> LabelValue 1 (what is this too?)

> LogBase 0

> Max Auto

> Min Auto

> MinorStep 0

> Notify False (what is this?)

> Position

> ScaleUnit 1

> Staggered False

> Step 0

> Visible True

>

>

>

>

> "SoftwareFX Support" <noreply@softwarefx.com> wrote in message

> news:h1Q$cUBVGHA.3544@webserver3.softwarefx.com...

>> Simply set:

>>

>> AxisY.ForceZero = false in the property grid.

>>

>> --

>> Francisco Padron

>> www.chartfx.com

>>

>

>

Link to comment
Share on other sites

The y-values don't show up.  I think this is because the min can be 99.99999 

and the max is 100%.

There are no y-values showing up.

-Lori

"Lori Adams" <ladams@cloudmark.com> wrote in message

news:C3a7mgDVGHA.3544@webserver3.softwarefx.com...

> That's still not quite working, and definitely wouldn't work if I don't

> want the most max value to be whatever auto thought it was (currently

> 100%).

>

>

> Below is what I am trying to achieve, and what my current settings are. I

> know have no y-axis values showing.

> Information:

> a) the values used as y-axis are retrieved from db as decimals (they

> can be changed to floats if needed). Anywhere from .00 to .999999

> B) have the y-axis values represented as percentages. So if value was

> .85, show as 85%

> c) only show y-axis values between 100% and the smallest value obtained

> from db.

>

> Currently my settings are (for the Y-axis):

> AutoScroll false (what is this?)

> customgridlines (collectio)

> firstLabel 0

> ForceZero False

> LabelsFormat

> CustomFormat

> Decimals 0

> Format Percentage

> LabelValue 1 (what is this too?)

> LogBase 0

> Max Auto

> Min Auto

> MinorStep 0

> Notify False (what is this?)

> Position

> ScaleUnit 1

> Staggered False

> Step 0

> Visible True

>

>

>

>

> "SoftwareFX Support" <noreply@softwarefx.com> wrote in message

> news:h1Q$cUBVGHA.3544@webserver3.softwarefx.com...

>> Simply set:

>>

>> AxisY.ForceZero = false in the property grid.

>>

>> --

>> Francisco Padron

>> www.chartfx.com

>>

>

>

Link to comment
Share on other sites

So I'm a lot closer than I was.

Because I want percents, and the values are decimal, the firstlabel value

has to be 0, not 1.

By setting Decimals to 5, and Format to Percentage, I see y-axis starting at

99.99994% through 100.00000%.

What is the trick to getting, 100.000000% to look like 100%, but for the

others to show their values. If I don't leave the decimals and format as

stated above, only the 100% shows and no other axis.

-Lori

"Lori Adams" <ladams@cloudmark.com> wrote in message

news:V8uJXNEWGHA.220@webserver3.softwarefx.com...

> The y-values don't show up. I think this is because the min can be

> 99.99999 and the max is 100%.

>

> There are no y-values showing up.

>

> -Lori

>

>

> "Lori Adams" <ladams@cloudmark.com> wrote in message

> news:C3a7mgDVGHA.3544@webserver3.softwarefx.com...

>> That's still not quite working, and definitely wouldn't work if I don't

>> want the most max value to be whatever auto thought it was (currently

>> 100%).

>>

>>

>> Below is what I am trying to achieve, and what my current settings are.

>> I know have no y-axis values showing.

>> Information:

>> a) the values used as y-axis are retrieved from db as decimals (they

>> can be changed to floats if needed). Anywhere from .00 to .999999

>> B) have the y-axis values represented as percentages. So if value was

>> .85, show as 85%

>> c) only show y-axis values between 100% and the smallest value

>> obtained from db.

>>

>> Currently my settings are (for the Y-axis):

>> AutoScroll false (what is this?)

>> customgridlines (collectio)

>> firstLabel 0

>> ForceZero False

>> LabelsFormat

>> CustomFormat

>> Decimals 0

>> Format Percentage

>> LabelValue 1 (what is this too?)

>> LogBase 0

>> Max Auto

>> Min Auto

>> MinorStep 0

>> Notify False (what is this?)

>> Position

>> ScaleUnit 1

>> Staggered False

>> Step 0

>> Visible True

>>

>>

>>

>>

>> "SoftwareFX Support" <noreply@softwarefx.com> wrote in message

>> news:h1Q$cUBVGHA.3544@webserver3.softwarefx.com...

>>> Simply set:

>>>

>>> AxisY.ForceZero = false in the property grid.

>>>

>>> --

>>> Francisco Padron

>>> www.chartfx.com

>>>

>>

>>

>

>

Link to comment
Share on other sites

So I'm a lot closer than I was.

Because I want percents, and the values are decimal, the firstlabel value

has to be 0, not 1.

By setting Decimals to 5, and Format to Percentage, I see y-axis starting at

99.99994% through 100.00000%.

What is the trick to getting, 100.000000% to look like 100%, but for the

others to show their values. If I don't leave the decimals and format as

stated above, only the 100% shows and no other axis.

-Lori

"Lori Adams" <ladams@cloudmark.com> wrote in message

news:V8uJXNEWGHA.220@webserver3.softwarefx.com...

> The y-values don't show up. I think this is because the min can be

> 99.99999 and the max is 100%.

>

> There are no y-values showing up.

>

> -Lori

>

>

> "Lori Adams" <ladams@cloudmark.com> wrote in message

> news:C3a7mgDVGHA.3544@webserver3.softwarefx.com...

>> That's still not quite working, and definitely wouldn't work if I don't

>> want the most max value to be whatever auto thought it was (currently

>> 100%).

>>

>>

>> Below is what I am trying to achieve, and what my current settings are.

>> I know have no y-axis values showing.

>> Information:

>> a) the values used as y-axis are retrieved from db as decimals (they

>> can be changed to floats if needed). Anywhere from .00 to .999999

>> B) have the y-axis values represented as percentages. So if value was

>> .85, show as 85%

>> c) only show y-axis values between 100% and the smallest value

>> obtained from db.

>>

>> Currently my settings are (for the Y-axis):

>> AutoScroll false (what is this?)

>> customgridlines (collectio)

>> firstLabel 0

>> ForceZero False

>> LabelsFormat

>> CustomFormat

>> Decimals 0

>> Format Percentage

>> LabelValue 1 (what is this too?)

>> LogBase 0

>> Max Auto

>> Min Auto

>> MinorStep 0

>> Notify False (what is this?)

>> Position

>> ScaleUnit 1

>> Staggered False

>> Step 0

>> Visible True

>>

>>

>>

>>

>> "SoftwareFX Support" <noreply@softwarefx.com> wrote in message

>> news:h1Q$cUBVGHA.3544@webserver3.softwarefx.com...

>>> Simply set:

>>>

>>> AxisY.ForceZero = false in the property grid.

>>>

>>> --

>>> Francisco Padron

>>> www.chartfx.com

>>>

>>

>>

>

>

Link to comment
Share on other sites

What would you like to see in the Y-Axis ?

The problem here is that you want to display a scale that requires that

amount of decimals in order to display. If you have 0 decimals, then he axis

can only display 99 and 100, it can not display 99.99994.

--

Francisco Padron

www.chartfx.com

"Lori Adams" <ladams@cloudmark.com> wrote in message

news:m9QXnxcWGHA.220@webserver3.softwarefx.com...

> So I'm a lot closer than I was.

> Because I want percents, and the values are decimal, the firstlabel value

> has to be 0, not 1.

> By setting Decimals to 5, and Format to Percentage, I see y-axis starting

> at 99.99994% through 100.00000%.

> What is the trick to getting, 100.000000% to look like 100%, but for the

> others to show their values. If I don't leave the decimals and format as

> stated above, only the 100% shows and no other axis.

>

>

> -Lori

>

>

> "Lori Adams" <ladams@cloudmark.com> wrote in message

> news:V8uJXNEWGHA.220@webserver3.softwarefx.com...

>> The y-values don't show up. I think this is because the min can be

>> 99.99999 and the max is 100%.

>>

>> There are no y-values showing up.

>>

>> -Lori

>>

>>

>> "Lori Adams" <ladams@cloudmark.com> wrote in message

>> news:C3a7mgDVGHA.3544@webserver3.softwarefx.com...

>>> That's still not quite working, and definitely wouldn't work if I don't

>>> want the most max value to be whatever auto thought it was (currently

>>> 100%).

>>>

>>>

>>> Below is what I am trying to achieve, and what my current settings are.

>>> I know have no y-axis values showing.

>>> Information:

>>> a) the values used as y-axis are retrieved from db as decimals (they

>>> can be changed to floats if needed). Anywhere from .00 to .999999

>>> B) have the y-axis values represented as percentages. So if value

>>> was .85, show as 85%

>>> c) only show y-axis values between 100% and the smallest value

>>> obtained from db.

>>>

>>> Currently my settings are (for the Y-axis):

>>> AutoScroll false (what is this?)

>>> customgridlines (collectio)

>>> firstLabel 0

>>> ForceZero False

>>> LabelsFormat

>>> CustomFormat

>>> Decimals 0

>>> Format Percentage

>>> LabelValue 1 (what is this too?)

>>> LogBase 0

>>> Max Auto

>>> Min Auto

>>> MinorStep 0

>>> Notify False (what is this?)

>>> Position

>>> ScaleUnit 1

>>> Staggered False

>>> Step 0

>>> Visible True

>>>

>>>

>>>

>>>

>>> "SoftwareFX Support" <noreply@softwarefx.com> wrote in message

>>> news:h1Q$cUBVGHA.3544@webserver3.softwarefx.com...

>>>> Simply set:

>>>>

>>>> AxisY.ForceZero = false in the property grid.

>>>>

>>>> --

>>>> Francisco Padron

>>>> www.chartfx.com

>>>>

>>>

>>>

>>

>>

>

>

Link to comment
Share on other sites

What would you like to see in the Y-Axis ?

The problem here is that you want to display a scale that requires that

amount of decimals in order to display. If you have 0 decimals, then he axis

can only display 99 and 100, it can not display 99.99994.

--

Francisco Padron

www.chartfx.com

"Lori Adams" <ladams@cloudmark.com> wrote in message

news:m9QXnxcWGHA.220@webserver3.softwarefx.com...

> So I'm a lot closer than I was.

> Because I want percents, and the values are decimal, the firstlabel value

> has to be 0, not 1.

> By setting Decimals to 5, and Format to Percentage, I see y-axis starting

> at 99.99994% through 100.00000%.

> What is the trick to getting, 100.000000% to look like 100%, but for the

> others to show their values. If I don't leave the decimals and format as

> stated above, only the 100% shows and no other axis.

>

>

> -Lori

>

>

> "Lori Adams" <ladams@cloudmark.com> wrote in message

> news:V8uJXNEWGHA.220@webserver3.softwarefx.com...

>> The y-values don't show up. I think this is because the min can be

>> 99.99999 and the max is 100%.

>>

>> There are no y-values showing up.

>>

>> -Lori

>>

>>

>> "Lori Adams" <ladams@cloudmark.com> wrote in message

>> news:C3a7mgDVGHA.3544@webserver3.softwarefx.com...

>>> That's still not quite working, and definitely wouldn't work if I don't

>>> want the most max value to be whatever auto thought it was (currently

>>> 100%).

>>>

>>>

>>> Below is what I am trying to achieve, and what my current settings are.

>>> I know have no y-axis values showing.

>>> Information:

>>> a) the values used as y-axis are retrieved from db as decimals (they

>>> can be changed to floats if needed). Anywhere from .00 to .999999

>>> B) have the y-axis values represented as percentages. So if value

>>> was .85, show as 85%

>>> c) only show y-axis values between 100% and the smallest value

>>> obtained from db.

>>>

>>> Currently my settings are (for the Y-axis):

>>> AutoScroll false (what is this?)

>>> customgridlines (collectio)

>>> firstLabel 0

>>> ForceZero False

>>> LabelsFormat

>>> CustomFormat

>>> Decimals 0

>>> Format Percentage

>>> LabelValue 1 (what is this too?)

>>> LogBase 0

>>> Max Auto

>>> Min Auto

>>> MinorStep 0

>>> Notify False (what is this?)

>>> Position

>>> ScaleUnit 1

>>> Staggered False

>>> Step 0

>>> Visible True

>>>

>>>

>>>

>>>

>>> "SoftwareFX Support" <noreply@softwarefx.com> wrote in message

>>> news:h1Q$cUBVGHA.3544@webserver3.softwarefx.com...

>>>> Simply set:

>>>>

>>>> AxisY.ForceZero = false in the property grid.

>>>>

>>>> --

>>>> Francisco Padron

>>>> www.chartfx.com

>>>>

>>>

>>>

>>

>>

>

>

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...