User (Legacy) Posted March 28, 2006 Report Share Posted March 28, 2006 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 More sharing options...
User (Legacy) Posted March 28, 2006 Author Report Share Posted March 28, 2006 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 More sharing options...
Software FX Posted March 29, 2006 Report Share Posted March 29, 2006 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 More sharing options...
Software FX Posted March 29, 2006 Report Share Posted March 29, 2006 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 More sharing options...
User (Legacy) Posted March 29, 2006 Author Report Share Posted March 29, 2006 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 More sharing options...
User (Legacy) Posted March 29, 2006 Author Report Share Posted March 29, 2006 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 More sharing options...
Software FX Posted March 30, 2006 Report Share Posted March 30, 2006 Simply set: AxisY.ForceZero = false in the property grid. -- Francisco Padron www.chartfx.com Link to comment Share on other sites More sharing options...
Software FX Posted March 30, 2006 Report Share Posted March 30, 2006 Simply set: AxisY.ForceZero = false in the property grid. -- Francisco Padron www.chartfx.com Link to comment Share on other sites More sharing options...
User (Legacy) Posted March 30, 2006 Author Report Share Posted March 30, 2006 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 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 More sharing options...
User (Legacy) Posted March 30, 2006 Author Report Share Posted March 30, 2006 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 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 More sharing options...
Software FX Posted March 31, 2006 Report Share Posted March 31, 2006 What are you getting in the Y-Axis ? It seems to me that you have everything set-up to get what you need. Currently, we do not support formulas for the Axis Min/Max but I still think what you need can be achieve without them. -- Francisco Padron www.chartfx.com Link to comment Share on other sites More sharing options...
Software FX Posted March 31, 2006 Report Share Posted March 31, 2006 What are you getting in the Y-Axis ? It seems to me that you have everything set-up to get what you need. Currently, we do not support formulas for the Axis Min/Max but I still think what you need can be achieve without them. -- Francisco Padron www.chartfx.com Link to comment Share on other sites More sharing options...
User (Legacy) Posted April 4, 2006 Author Report Share Posted April 4, 2006 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 > 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 More sharing options...
User (Legacy) Posted April 4, 2006 Author Report Share Posted April 4, 2006 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 > 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 More sharing options...
User (Legacy) Posted April 6, 2006 Author Report Share Posted April 6, 2006 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 >> 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 More sharing options...
User (Legacy) Posted April 6, 2006 Author Report Share Posted April 6, 2006 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 >> 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 More sharing options...
Software FX Posted April 9, 2006 Report Share Posted April 9, 2006 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 >>> 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 More sharing options...
Software FX Posted April 9, 2006 Report Share Posted April 9, 2006 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 >>> 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.