469,945 Members | 2,267 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Field Expressions in SSRS-2005 Reports

14
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 1134

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 this site, you agree to our Privacy Policy and Terms of Use.