CODEWITHSUNDEEP
reporting-servicesreportvisual-studio-2005
Mimi
Mimi

Reputation: 389

Showing "#Error" in ssrs 2005 report

In a field of my groupfooter section of a table I am writing This, 

=FormatPercent(IIf((Fields!TotalTask_p1.Value+Fields!SuperVisorsCode.Value)>0,(Fields!TotalCommittedTask_p1.Value+Fields!SuperVisorsCode.Value)/(Fields!TotalTask_p1.Value+Fields!SuperVisorsCode.Value),0))

It is not raising any build error. But when I preview the report it shows "#Error" in that field. What should be done?

Upvotes: 1

Views: 127

Answers (1)

Mahesh
Mahesh

Reputation: 8892

You need make sure both the divider value are non zero and also make sure the right conversion is done lots of time thee error raise in ssrs expression is due to the fact that conversion is not done.And also make sure the all the values in column are numeric.

 =FormatPercent(IIF((CInt(Fields!TotalTask_p1.Value) + CInt(Fields!SuperVisorsCode.Value)) > 0 ,    
  (CInt(Fields!TotalCommittedTask_p1.Value) + CInt(Fields!SuperVisorsCode.Value))/(Cint(Fields!TotalTask_p1.Value) + CInt(Fields!SuperVisorsCode.Value))
  ,0))

Upvotes: 1

Related Questions