lagyossarian
New member
- Local time
- Yesterday, 20:23
- Joined
- Sep 14, 2009
- Messages
- 1
I have a formula field in a report:
If {Nec_Gnav_ReportViewer_Data_AgentAlertsReport_AgentAlertData.LevelOne} = true then Chr(254) else Chr(168)
It works fine unless the dataset the report template binds to is empty or null. Then it gives me an error saying it expects a string. So, I tried to trap for a null field like this:
If (Not IsNull({Nec_Gnav_ReportViewer_Data_AgentAlertsReport_AgentAlertData.LevelOne})) Then
If {Nec_Gnav_ReportViewer_Data_AgentAlertsReport_AgentAlertData.LevelOne} = true then Chr(254) else Chr(168)
Else Chr(168)
However, that did not work either -- probably because of the no data again.
I am at a loss here how to handle this. Any suggestions/guidance/help is much appreciated. Thanks in advance.
If {Nec_Gnav_ReportViewer_Data_AgentAlertsReport_AgentAlertData.LevelOne} = true then Chr(254) else Chr(168)
It works fine unless the dataset the report template binds to is empty or null. Then it gives me an error saying it expects a string. So, I tried to trap for a null field like this:
If (Not IsNull({Nec_Gnav_ReportViewer_Data_AgentAlertsReport_AgentAlertData.LevelOne})) Then
If {Nec_Gnav_ReportViewer_Data_AgentAlertsReport_AgentAlertData.LevelOne} = true then Chr(254) else Chr(168)
Else Chr(168)
However, that did not work either -- probably because of the no data again.
I am at a loss here how to handle this. Any suggestions/guidance/help is much appreciated. Thanks in advance.