468,251 Members | 1,372 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,251 developers. It's quick & easy.

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.

Aug 22 '07 #1
1 3742
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.

Aug 22 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Claus Haslauer | last post: by
reply views Thread by Marcin Zmyslowski | last post: by
1 post views Thread by Scott H. | last post: by
reply views Thread by Henry Seymour | last post: by
7 posts views Thread by John | last post: by
2 posts views Thread by DaveD170 | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.