[HELP] SSRS CrossTab givin weird results

• wilyrama

  Newbie

  Points: 3

  More actions

  January 7, 2009 at 2:08 am

  #199838

  here is the database :

  [Code]

  PersonYearPeriodePoint

  A2008165

  A2008288

  [/Code]

  i make a crosstab SSRS with this specification :

  Report Parameter: Year

  Row Dimension: Person

  Column Dimension: Periode

  Measure: Point

  logically the result should be like this...

  [Code]

  Periode

  12

  A 6588

  [/Code]

  But the results r like this :

  [Code]

  Periode

  12

  A65

  A88

  [/Code]

  what did i miss ???

  can anyone help ???

  i'm gettin frustated here....

• Niraj-627298

  Hall of Fame

  Points: 3641

  More actions

  January 7, 2009 at 3:24 am

  #922394

  Hi...

  Greetings for the day...

  Well, I tried this jst now..and it is giving here the expected results..

  I would suggest you to try it once again...taking..Year on columns first and then dragging Pericode field later above the Year field...(it means..we doing nothing new here...still..give it a try)....

  Please let me knw...abt the same..

  Thanks alot,

  Niraj

• Dave Balsillie

  SSCertifiable

  Points: 5589

  More actions

  January 8, 2009 at 12:05 pm

  #923615

  Check the Person field carefully for things like trailing spaces (i.e. "A" and "A "). I've seen that more than once.