Issues creating a report template using a table format

TimWeisbrod

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.

TylerGraham2

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.