Background
- I am working on a report containing multiple text box controls.
- Given a record of my source Table, those controls have for data source different columns of my table.
- The data retrieved should be numbers, but for some reason, my table sometimes contains empty/null values instead of having a zero.(this is a cross tab...)
My problem:
- If I try to make a sum of a set of controls that contains a null/empty value it returns null/empty
Question:
What is the trick to handle this without modifying the table (cross tab... not easy to modify).
I tried something like:
Switch(["Name of Control"]="",0)
but does not work.
Could somebody help on this?
Cheers,
Seb
- I am working on a report containing multiple text box controls.
- Given a record of my source Table, those controls have for data source different columns of my table.
- The data retrieved should be numbers, but for some reason, my table sometimes contains empty/null values instead of having a zero.(this is a cross tab...)
My problem:
- If I try to make a sum of a set of controls that contains a null/empty value it returns null/empty
Question:
What is the trick to handle this without modifying the table (cross tab... not easy to modify).
I tried something like:
Switch(["Name of Control"]="",0)
but does not work.
Could somebody help on this?
Cheers,
Seb