I have a basic form setup to record “Loads”.
Here is a section of the Report Template.
Load Type 1: <<[Load Type 1]>> Load Count 1: <<[Load Count 1]>> Load Circuit Time 1: <<[Load Circuit Time 1]>> <<IF: ISNOTBLANK([Load Type 2])>>Load Type 2: <<[Load Type 2]>> Load Count 2: <<[Load Count 2]>> Load Circuit Time 2: <<[Load Circuit Time 2]>><<EndIf>> <<IF: ISNOTBLANK([Load Type 3])>>Load Type 3: <<[Load Type 3]>> ...... Total Loads: <<[Total Loads]>>
You can see that the app always expects information for Load Type 1.
From then on though it checks to see if data has been put in before displaying it.
When I run this report I receive this error:
...Expression '[Load Type 1]' is invalid due to: Unable to find column 'Load Type 1'...
Please note this error continues on for all other columns and expressions but starts at Load Type 1
Comparing my report to the error I can see they are exact copies no issues with extra spaces etc.
Text from data > columns > table name
Load Count 1
From the report
<<[Load Count 1]>>
Does anyone know what else could cause this behaviour?