Data missing on the report

• pwalter83

  SSChampion

  Points: 14575

  More actions

  January 5, 2012 at 3:42 am

  #252994

  Issue Resolved - Just created a new rdl file by copying the old one and it started displaying the whole data for 2011, I really dont know how and why !!

  -----------------------------------------------------------------------------------------

  Hi,

  I am testing a report which is based on the year parameter selected. The problem I am facing is when I select the year 2011, some data goes missing but it does not happen for the years - 2010 and 2012. The missing data is listed under Jan to dec calendar months.

  I have checked that the data exists for 2011 in SQL and also appears under the Data mode. Also, there are no hidden visibility or expressions that would restrict data for 2011.

  Does anyone have any idea why this would happen ? I have attached screenshots for the periods 2011 and 2012. Pls note that the columns for Jan till dec are missing in 2011.

  Would appreciate any suggestions.

  Thanks,

  Paul

  ------------------------------------------------------------------------------