Mail Merge Reports

Create documents in docx, xlsx (MS Office Word and Excel), odt, ods (LibreOffice and OpenOffice) and pdf format without MS Office or others plugins installed from any module and subpanel using templates.

Includes a 30 day guarantee

Try it Now

By clicking you consent to share your profile with the developer

#1769 - Data from relationships not showing in the body section of document via [a_subX.varname]

Closed General Question created by raskew 8 years ago

When generating a document I am noticing that related data is not showing the the a body block when referenced. for instance, if the following block existed:

[a;block=w:body;sub1=relation1;sub2=relation3;sub3=relation3]

The date for {a_sub1.name] and [a_sub3.name] is not showing although it is populated. However the data for [a_sub2.name] mysteriously appears. All relations are populated. When showing the relations in a table row block on their own. The data appears, such as:

[a_sub1;block=w:tr][a_sub1.name]

Izertis Provider
8 years ago

Hi,

The problem is very strange. Please, could you give us more information?. And, also, please, send us your template in order to review it.

Regards,

Anabel

reply
raskew
8 years ago

Sure I can do that. What email address should I forward the information.

reply
- Izertis Provider
  8 years ago
  
  Adonadios@izertis.com
  
  reply
raskew
8 years ago

Email was sent with attachments.

reply
Izertis Provider
8 years ago

Hi,

I have just sent you an email: the problem in your template is that you have to declare blocks to obtain data from a subpanel, please, review the template example that I sent by email.

Regards,

Anabel

reply
raskew
8 years ago

Hello Anabel.

I understand blocks, but I don't want to display all the records from a subpanel. I only want to get 1 record from the subpanel. In the earlier example I sent you it worked for the insurance subpanel, but it didn't work for the other subpanels.

Regards,

Roger

reply
Izertis Provider
8 years ago

Hi Roger,

In order to have only the first record of a subpanel you can use a special tinyButStrong sintaxis. Instead to declare the variable as: [a_sub3;block=w:p][a_sub3.name]

You have to declare it as: [a_sub3;block=w:p;when [a_sub3.#]=1][a_sub3.name]

I have just sent a template by email,

Regards,

Anabel

reply