I'm trying to figure out why a certain SSRS report is creating bizarre lines. I've taken the code over to the management studio and am trying to run it there. I keep getting a divide by zero error encountered but the line it references (and highlights) has no division in it. This is the line it is saying there is an issue on
SELECT 1 AS Grouper, CR.*, TotalYrBalance, TotalBalance, TotalProject, Average,
I've moved the line up and down and it always errors out on this line. I don't now how it can be. Because I can't get past this error, I can't figure out what is wrong with my SSRS report. And when I try and run the code from the SSRS side of things I get a bizarre CLR type does not exist or you do not have permission to access it.
Note - the report does run fine and the majority of the lines are fine.... it's just when I have a certain kind of record that it randomly puts odd dollars in the report. I'm trying to trouble shoot this random problem.