require Query Fromat

• ECN INdia

  SSC Enthusiast

  Points: 106

  More actions

  February 16, 2006 at 2:40 am

  #110987

  table has a field 'A' containing numeric value...

  Want a field 'B' to display to cumulative data of row 'A'

  where ,

  B1=A1, B2=B1+A2 , B3=B2+A3 .....

  Here 'B' is not a table field..

  it is just for display purpous on Report..

  ......................................................................................

  column 'A' has following values in desc order : 5,5,4,4,4,3,3,2,2,1

  So 'B' should have 5,10,14,18,22,25,28,30,32,33

  .......................................................................................

  i m working on Ms SQL server 2005 reporting services ..

• Joseph Mulhall

  SSCarpal Tunnel

  Points: 4672

  More actions

  February 16, 2006 at 5:38 am

  #621325

  What happens when your is reordered?

  You need to normalize the data.