September 22, 2014 at 10:23 am
I created a SSRS report using a stored proc in Visual Studio 2008. The report displays student attendance percentages for multiple schools. Attendance always defaults to present unless changed by the school administrator. Therefore if a school does not enter attendance for a specific day, the report shows that there is 100% attendance for that day. THIS IS A DESIRED RESULT. The problem is that when the report is published in SSRS report manager, instead of the report showing 100% for a school that did not enter absences, the field is blank, WHICH IS NOT A DESIRED RESULT. The report must show 100% in this case.
If I run the stored proc, I see 100%. If I run the report in Visual Studio, I see 100%. If I run the report from report manager, I see a blank field (does not show 100%).
Any thoughts?
September 24, 2014 at 3:02 pm
Is the report pointing to same data source in SSRS that it points to in Visual Studio? That's the only thing I can think of right off.
September 25, 2014 at 9:29 pm
Well, I'm embarrassed. The problem was in my code and how it was, or actually was not, handling NULL values. Once I put in an ISNULL statement the problem was resolved.
Thank you for your response.
Dan Tuma
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply