472,099 Members | 2,380 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,099 software developers and data experts.

Field Expressions in SSRS-2005 Reports

I'm Working with SSRS-2005 Reports in C# Web Applications..

I'm having One Doubt regarding Division..
In Chart Control (Pie-Chart Type)
(Properties--> Data--> Values--> (Select Edit)--> EditChartValues--> PointLabels-->Label-Expression)
I'm Using the Following expression..

=Floor((Fields!Price.Value*100)/Sum(Fields! CPU.Value, "DataSet1_AmountDetails")) & "%"

In Chart Control(Pie-Chart Type).. I'm getting Output as..
10%, 15%, 12%, 7%, 27%, 14%, 14% ...

If I'm Using the Following Expression in Chart Control (ie I'm Not Including FLOOR here)..

=((Fields!Price.Value*100)/Sum(Fields!CPU.Value, "DataSet1_AmountDetails")) & "%"

In Chart Control(Pie-Chart Type).. I'm getting Output as..
10.2564789456%, 15.457893652145%, 12.877895632%, 7.9845678987%, 27.12348532%, 14.6547863254%, 14.7550103026% ........

Even I Used ROUND in My expression..
I'm getting my Out put as..
10%, 15%, 13%, 8%, 27%, 15%, 15%..

which gives me the Total Percentage is More than 100%.. I want to show my Reports for Only 100%...
This is the Problem i'm facing when i'm Using Round

But I Want the OutPut as
10.25%, 15.45%, 12.87%, 7.98%, 27.12%, 14.65%, 14.75%...

How can I do this... Please give me the Suggestions for doing this...

Thank You..
Mar 4 '08 #1
0 1201

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by aaron.kempf | last post: by
reply views Thread by Wes Groleau | last post: by
reply views Thread by akhedle | last post: by
3 posts views Thread by chinni0719 | last post: by
reply views Thread by fresher1 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.