- 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)
Tuesday, March 14, 2017
SSRS Fails - Reports timeout, SSRS does not export to Excel, Reports take extremely long to run. OutofResources exception error
All of these errors are related to having some sql or ssrs function or formula that is being fed nulls.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment