I don't know its a bug or what , in our database the "Year" columns comes without any decimal places ,also in the criteria section of the report ,I have made the data format "with '0' decimal places ", but still in the column prompt in the dashboard , I am getting year value with decimal places .
Eg. 2012 coming as 2012.00 in choice list of the prompts . Can you provide me any work around? for that thanks in advance..
The problem is due the data type of the column . Go to the physical layer and check the data type . It would be of 'Double' data type .. Change it to 'Int' data type. This would solve the problem . Posting it for the benefit of others who face similar issues. let me know if it helps anyone..