Format Units on ReportViewer chart axis - DOTNET

This is a discussion on Format Units on ReportViewer chart axis - DOTNET ; Hi there, I have an asp.net 2 application, and created a local report using MS ReportViewer. The report consists of a line chart, with date intervals on the x axis, and amounts of money in the y axis. It all ...

+ Reply to Thread
Results 1 to 2 of 2

Format Units on ReportViewer chart axis

  1. Default Format Units on ReportViewer chart axis

    Hi there, I have an asp.net 2 application, and created a local report
    using MS ReportViewer. The report consists of a line chart, with date
    intervals on the x axis, and amounts of money in the y axis.

    It all works fine, but the amounts of money are high (in millions),
    and so the y axis shows increments of 10000000 and has amounts showing
    on the grid lines of 10000000, 20000000, 30000000, 40000000 etc.

    I would like to format these to a currency amount, or at least have
    some commas to make it more readable, but if I try using eg
    =FormatCurrency(Fields!MyAmount.Value) the chart is not output
    correctly.

    Can anyone suggest any way to solve this? Hope this post makes sense.


  2. Default RE: Format Units on ReportViewer chart axis

    Hi Andy,
    I used Reporting Services only once and I have never used charts. But
    tables allow to set up Format property for each column. I used it with Data
    Time objects and it worked fine. You can set up this format in .net manner.
    Just be sure your data are returning from query in correct type - currency =
    Money in sql server otherwise formating will not occure (at least this
    happend with datetime).

    Regards,
    Ladislav

    "Andy" wrote:

    > Hi there, I have an asp.net 2 application, and created a local report
    > using MS ReportViewer. The report consists of a line chart, with date
    > intervals on the x axis, and amounts of money in the y axis.
    >
    > It all works fine, but the amounts of money are high (in millions),
    > and so the y axis shows increments of 10000000 and has amounts showing
    > on the grid lines of 10000000, 20000000, 30000000, 40000000 etc.
    >
    > I would like to format these to a currency amount, or at least have
    > some commas to make it more readable, but if I try using eg
    > =FormatCurrency(Fields!MyAmount.Value) the chart is not output
    > correctly.
    >
    > Can anyone suggest any way to solve this? Hope this post makes sense.
    >
    >


+ Reply to Thread

Similar Threads

  1. Intensity chart and Logarithmic Y axis !
    By Application Development in forum labview
    Replies: 0
    Last Post: 10-31-2007, 10:10 AM
  2. Re: change labels of multiple axis in xy-chart
    By Application Development in forum labview
    Replies: 0
    Last Post: 10-26-2007, 07:40 AM
  3. overlay chart with latest x/y-axis value
    By Application Development in forum Graphics
    Replies: 1
    Last Post: 02-17-2006, 10:49 PM
  4. Axis number format
    By Application Development in forum Graphics
    Replies: 4
    Last Post: 09-23-2005, 01:03 PM
  5. Changing the Axis Scale in MS Chart
    By Application Development in forum basic.visual
    Replies: 0
    Last Post: 05-25-2004, 12:52 AM