hi we are currently on 2014 enterprise and will be on 2019 enterprise in the coming months.
on at least 24 of our reports, there is a set of parameters called minimum balance and maximum balance. I can get into a long explanation about negatives meaning the customer owes us and positives meaning we owe him, but the bottom line for this question is that by definition zero is invalid for a min or max balance.
i suspect that is difficult if not impossible to control from ssrs. who knows. maybe there is a way to introduce an ssrs expression based function before the proc is run?
so we are thinking about either throwing an exception in the proc or returning one liners to our tablix's with the appropriate error. exceptions sound like the more appropriate way to go but then we wonder about the whole "enabling remote errors" thing being a prerequisite to the user understanding what he sees once we throw the exception.
can someone guide us on best practice? we dont enable remote errors right now and i dont think we will be doing that.