Report IF statement error?

[Patrick_Paul]

Argh, reports will be the death of me. A report template I have has the following bit in it:

Date Scheduled: <<[Actual Scheduled Date]>> <<if: OR([Actual Scheduled Date]<[Last Assessment Date],[Actual Scheduled Date]<today())>>
<<Please schedule a new assessment date in the TTS system or contact your area’s trainer.>><> <-This says “end if” in double pointy-brackets but it doesn’t show up when I type it in the resulting post…

It fails and yields this error message in the log. I can’t figure out why:

“Errors”: “Error: Report ‘TT report -Weekly’ action ‘Action 1’ Body template. Expression ‘Assessment Overdue!’ is invalid due to: Expression refers to undefined field. Error: Report ‘TT report -Weekly’ action ‘Action 1’ Body template. Expression ‘Please schedule a new assessment date in the TTS system or contact your area’s TDP Trainer.’ is invalid due to: Expression ‘Please schedule a new assessment date in the TTS system or contact your area’s TDP Trainer.’ could not be parsed due to exception: Unterminated string…”,

[Steve · Accepted solution]

Your template:

Date Scheduled: <<[Actual Scheduled Date]>>  <<if: OR([Actual Scheduled Date]<[Last Assessment Date],[Actual Scheduled Date]<today())>>
<<Please schedule a new assessment date in the TTS system or contact your area’s trainer.>><<endif>>

This:

Please schedule a new assessment date in the TTS system or contact your area’s trainer.

should not be enclosed in << >>.

Date Scheduled: <<[Actual Scheduled Date]>>  <<if: OR([Actual Scheduled Date]<[Last Assessment Date],[Actual Scheduled Date]<today())>>
Please schedule a new assessment date in the TTS system or contact your area’s trainer.<<endif>>