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

• Aswanth

  SSChasing Mays

  Points: 608

  More actions

  March 3, 2008 at 11:02 pm

  #183393

  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.1457895632%, 7.12345678987%, 27.12348532%, 14.12547863254%, 14.2350103026% ........

  =================================================================

  But I Want the OutPut as

  10.25%, 15.45%, 12.14%, 7.12%, 27.12%, 14.12%, 14.23%...

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

  Thank You..

• Ayan Mitra-618688

  SSC Veteran

  Points: 232

  More actions

  March 3, 2008 at 11:32 pm

  #784789

  Hi Aswanth!

  I am not very sure, but did you tried using this:

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

  -- See I am using Round insted of Floor.

  Pls check.

  Please consider environment before printing this message 🙂

• Aswanth

  SSChasing Mays

  Points: 608

  More actions

  March 4, 2008 at 12:14 am

  #784791

  Thank You for giving me the Reply..

  Even I Used ROUND in My expression as you Said to Me..

  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