Lava Report Columns Not Available for Export to Merge Document

[shelbysubia]

Description

Any value that is in a Lava report column will display as blank in a Merge Document if that field is exported using {{ Row.[ColumnKey] }} for that particular row & column.

Steps to Reproduce

1. Create a Financial Pledge Data View displaying all pledges to a specific financial account (mine had an id of 237).
2. Create a Person Data View displaying all people within the Financial Pledge Data View created in step 1.
3. Create a Person Report referencing the Person Report from step Attribute Caching #2, with the columns (Person) Id, Person Name, and Lava
4. Paste this lava in the Lava Field to get the total amount that individual has pledged to account 237

{% assign person = Id | PersonById %}
{% assign pledgetotal = '0' %}
{% for ppl in person.Aliases %}
    {% financialpledge where:'PersonAliasId == {{ppl.Id}}'%}
          {% for pledge in financialpledgeItems %}
             {% if pledge.Account.Id == '237' %}
                {% assign newpledge = pledge.TotalAmount %}
                {% assign pledgetotal = pledgetotal | Plus:newpledge %} 
             {% endif %}
          {% endfor %}
    {% endfinancialpledge %}
{% endfor %}
{{ pledgetotal | FormatAsCurrency }}

Here is a link to a screen recording in which these steps are done on the Rock Demo Site: https://tfhvv.sharepoint.com/:v:/g/IT/EeubQ_9FtehBornUR2lvHPkBgo5Uee6QJOLJcuLw9NNbkA?e=Jl8NAT

Here are screenshots:
Step 1.

Step 2.

Merge Document

Report Output

Expected behavior:

Any value that is returned via the Lava in a Lava column should be stored as a text value in that row, which can be exported to a Merge Document using the format {{ Row.[ColumnKey] }}

(Every person in this report will have a value in the Lava column (i.e. there will be no blanks), because our Data View is only displaying individuals that have made a pledge to account id 237).

Actual behavior:

The value is displayed correctly within the report, but when exported to a Merge Document, the value displays as blank.

Versions

• Rock Version: I encountered this bug on my Rock Version 7.5, and recreated on the demo site (Rock Version 8.5).
• Client Culture Setting: en-US

[shelbysubia]

Not sure how I accidentally closed it, sorry! First time posting on Github :)