All of these errors are related to having some sql or ssrs function or formula that is being fed nulls.
- Ensure that all lookup queries do not return any nulls for drop-down lookups
- Ensure that no nulls are passed to any SQL formulas in views you are using
- Ensure that no nulls are passed to any SSRS formulas in your report
- Ensure that all SSRS outputs are 0 or "(none)" but never NaN or Null or Infinite
- All nulls should be handled in SQL by ISNULL([field],0) or ISNULL([field],"(none)")
- All nulls should be handled in SSRS by
- =iif(isNothing(Fields!FV1.Value), Fields!FV2.Value, Fields!FV1.Value)
No comments:
Post a Comment