This is my first time trying to create a report template. I am not sure how to fix this error and I am looking for suggestions on that. I used the downloadable report template to provide syntax to insert into the following table, I keep getting the same error (Error: An error occurred when checking the report template. Failed to parse $(XXXayla_3_sample_is_taken_to) since XXXayla_3_sample_is_taken_to cannot be found in the current parsing scope.).
LOG OF TEST PIT NUMBER - ${hole_number_and_depth} | ||||||||||||||||||
| ||||||||||||||||||
OWNER: ${owner} | SURFACE / HOLE TOP ELEVATION: ${surface_elevation_feet} FLOOD PRONE AREA: ${flood_prone_areas} | COUNTY: ${county} | ||||||||||||||||
PRACTICE: ${practice} | PERCHED WATERTABLE ELEVATION: ${perched_water_table_elevation_f} TOP OF PERCHING LAYER ELEVATION: ${top_of_low_permeability_perchin} | LAT/LONG: ${lat_long}, ${type_in_latitude_longitude | appearance:"multiline"} | ||||||||||||||||
EQUIPMENT: ${equipment} | SEASONAL HIGH WATER TABLE ELEV. : ${seasonal_high_water_table_eleva} WETLANDS NEAR SITE: ${wetlands_near_the_site} | LANDSCAPE POSITION: ${landscape_position} SOIL MAP UNIT: ${soil_map_unit} | ||||||||||||||||
LOGGED BY: ${logged_by} | OBSERVED SUBSURFACE SATURATION ELEV. :${observed_significant_subsurface} OBSERVED “FREE” WATER ELEVATION: ${observed_free_water_elevation_f} | NATIONAL MAP BEDROCK: ${national_bedrock_geology} BEDROCK ENCOUNTERED: ${predominate_bedrock_type_encoun} | ||||||||||||||||
DATE: ${date_and_time} | TOP OF WEATHERED BEDROCK ELEVATION: ${top_of_weathered_bedrock_elevat} TOP OF COMPETENT BEDROCK ELEVATION: ${depth_to_competent_bedrock_feet} | KARST TYPE - NATIONAL MAP: ${united_states_karst_map} KARST FEATURES WITHIN 1000 FT: ${are_there_karst_features_sinkho} | ||||||||||||||||
DEPTH | USCS | GRADATION | PLASTICITY | MUNSELL COLOR AND % | MOISTURE | STRUCTURE | GEOLOGY | ADDITIONAL COMMENTS | SAMPLES | |||||||||
FROM |
TO |
SYMBOL |
GROUP NAME |
% B |
% C |
% G |
% S |
% FINE |
Non, Slightly, Low, Medium, High. |
MATRIX |
REDOX. |
Dry, Slightly Moist, Moist, Very Moist, Wet. |
Stratified, Laminated, Fissured, Slicken-sided, Blocky, Pris- matic, Lensed, Massive. | Alluvium, Slope Alluvium, Colluvium, Glacial Till, Glacial Lake Sediment, Outwash, Residuum, Loess, Bedrock. | Dilatancy: None, Slow, Rapid; Odor (mention if unusual); Consistency (Mention if very soft or soft in wet condition); Location of Seepage and Other Items such as caving or sloughing of pit and how the water enters the pit; Description of lenses and / or mixed materials encountered. |
FROM |
TO |
# |
(FT.) | (FT.) | (i.e-ML) | (i.e.-Silt w/Sand) | >12" | 3"-12" | 3"-1/4" | 1/4"-#200 | <#200 | (90% 10YR 4/4) | (10% 10YR 5/2) | (FT) | (FT) | ||||||
${beginning_depth_of_layer_1_in_f}
| ${ending_depth_of_layer_1_in_feet}
| ${layer_1_unified_soil_classifica}
| ${layer_1_full_uscs_group_name_wi}
| ${layer_1_boulders}
| ${layer_1_cobbles}
| ${layer_1_gravel}
| ${layer_1_sand}
| ${layer_1_fines_200_sieve}
| ${plasticity_pi_of_layer_1}
| ${layer_1_matrix_color_percent_of}% ${field_129} | ${layer_1_concentrated_redoximorp} ${field_75}%
${layer_1_reduced_redoximorphic_f}% ${field_78} | ${layer_1_moisture_estimate}
| ${layer_1_soil_structure}
| ${geology_of_layer_1}
| ${field_10 | appearance:"multiline"}
| ${layer_1_sample_is_taken_from} | ${layer_1_sample_is_taken_to} | ${layer_1_sample_name} |
${beginning_depth_of_layer_2_in_f}
| ${ending_depth_of_layer_2_in_feet}
| ${layer_2_unified_soil_classifica} | ${layer_2_full_uscs_group_name_wi} | ${layer_2_boulders}
| ${layer_2_cobbles}
| ${layer_2_gravel}
| ${layer_2_sand}
| ${layer_2_fines_200_sieve}
| ${plasticity_pi_of_layer_2}
| ${layer_2_matrix_color_percent_of}% ${layer_2_soil_matrix_munsell_col} | ${layer_2_concentrated_redoximorp}% ${field_114}
${layer_2_reduced_redoximorphic_f}% ${field_112} | ${layer_2_moisture_estimate}
| ${layer_2_soil_structure}
| ${geology_of_layer_2}
| ${additional_comments_about_layer | appearance:"multiline"}
| ${layer_2_sample_is_taken_from}
| ${field_104}
| ${layer_2_sample_name}
|
${beginning_depth_of_layer_3_in_f}
| ${ending_depth_of_layer_3_in_feet}
| ${layer_3_unified_soil_classifica}
| ${layer_3_full_uscs_group_name_wi}
| ${layer_3_boulders}
| ${layer_3_cobbles}
| ${layer_3_gravel}
| ${layer_3_sand}
| ${layer_3_fines_200_sieve}
| ${plasticity_pi_of_layer_3}
| ${layer_3_matrix_color_percent_of}% ${layer_3_soil_matrix_munsell_col} | ${layer_3_concentrated_redoximorp}% ${field_143}
${layer_3_reduced_redoximorphic_f}%
${field_141} | ${layer_3_moisture_estimate}
| ${layer_3_soil_structure} |
${geology_of_layer_3}
| ${field_135 | appearance:”multiline”}
| ${layer_3_sample_is_taken_from}
| ${ayla_3_sample_is_taken_to}
| ${ayla_3_sample_name}
|
${beginning_depth_of_layer_4_in_f} | ${ending_depth_of_layer_4_in_feet} | ${layer_4_unified_soil_classifica} | ${layer_4_full_uscs_group_name_wi} |
${ayla_4_boulders}
| ${ayla_4_cobbles} | ${layer_4_gravel}
| ${layer_4_sand}
| ${layer_4_fines_200_sieve}
| ${plasticity_pi_of_layer_4}
| ${layer_4_matrix_color_percent_of}% ${layer_4_soil_matrix_munsell_col} | ${field_169} ${layer_4_concentrated_redoximorp}
${field_167} ${layer_4_reduced_redoximorphic_f} | ${layer_4_moisture_estimate}
| ${layer_4_soil_structure}
| ${geology_of_layer_4}
| ${field_163 | appearance:"multiline"}
| ${layer_4_sample_is_taken_from}
| ${layer_4_sample_is_taken_to}
| ${layer_4_sample_name}
|
General Comments: ${general_comments | appearance:"multiline"}
BORING DEPTH:${depth_to_the_end_of_the_boring} ELEV. :${elevation_of_the_end_of_the_bor} REFUSAL TYPE: ${reason_for_ending_the_boring} | ||||||||||||||||||
DISCLAIMER: ALL SOIL CLASSIFICATIONS FIELD CHECKED. IF CONCLUSIVE SOIL CLASSIFICATION RESULTS ARE REQUIRED FOR ENGINEERING PURPOSES THEN SEND A SAMPLE OF IT TO THE LAB. |
What that is saying is it can't find a matching field in the layer to pull data from. This can happen a couple of ways.
First, make sure the field name matches exactly, for example if you have a field "Location" and in the template call ${location} you'll get the error. Looking at your table is the "ayla" part of the name supposed to be "layer"?
Make sure you're using squiggly brackets {} and not parenthesis () when calling fields in the template.
Also, if the field is in a repeat and you call it outside of the repeat table/layer you'll get the error. If you have a repeat called "locations" with a field named "Location" you need to open and close the repeat table.
${#locations}
{Location}
${/}
Conversely if you opened a repeat and forgot to close it with the ${/} you'll get the error.
And finally, sometimes it just hates you. I've found that if you open repeats or if statements in a table it gets really finicky throws that error because it doesn't like that you used a Word header style to open it and closed it with the formatting set as a body style.