Referenced rows in PFD for filtered views

[Sirotti]

Hello to everybody

I'm encountering a problem when trying to insert images from a referenced row in a PDF.

I'm creating an App for our vendors to obtain used vehicle evaluations. They are registered via mail, so each vendor has is own set of vehicles, their own set of photos and so on. For this I'm using 2 filtered slices, based on USERMAIL. They have both a VEICOLI PERSONALI slice and a FOTO PERSONALI slice.

In the VEICOLI PERSONALI slice I have a FOTO reference to FOTO PERSONALI, so the vendor can select one of his FOTO PERSONALI entry to provide documentation. This seems to work correcty.

My problem:

I'm trying to create a PFD template that shows all data for the VEICOLI PERSONALI entry, including the FOTO reference. Everything works fine except the references. 

My code to handle them is: 

<<Start:Veicoli personali[Foto]>> (Foto is the referenced row)

Foto 1: <<Foto personali[Foto 1]>> (Foto 1 contains the link to the image)
Foto 2: <<Foto personali[Foto 2]>> (Foto 2 contains the link to the image)

<<End>>

When I run the code I don't get any error, but the images are not showing, even if they display correctly in the FOTO PERSONALI view.

What am I doing wrong?

[Steve]

Try this instead:

Foto 1: <<[Foto 1].[name of Image column in Foto personali]>>
Foto 2: <<[Foto 2].[name of Image column in Foto personali]>>

[Sirotti]

Hello and thank you for your answer

This doesn't seem to work. I certainly have explained myself poorly:

- This is the source column, from the Veicoli Personali slice of the Veicoli table

This is REF slice

The Key and Label for the Foto Personali slice is a virtual column called Key Virtuale, defined as text with a formula. Foto 1 and Foto 2 (and all other photos) are defined as images.

I tried some variations, and they all turn up with errors. , for example  "Error encountered in step with name [Crea PDF richiesta RD]: Error: Task 'Crea PDF richiesta RD' Body template. Expression '[Foto 1].[Foto 1]' is invalid due to: Invalid dereference. Column Foto 1 is not a Ref."

If I use the formula 

<<Start:Veicoli personali[FOTO]>>

Foto 1: <<[Key virtuale].[Foto 1]>>
Foto 2 : <<[Key virtuale].[Foto 2]>>

<<End>>

I don't get errors, but no images are shown. 

I hope that my explanation is more clear this time.

[Steve]

What about this?

<<Start:Veicoli personali[FOTO]>>
Foto 1: <<[Foto 1]>>
Foto 2: <<[Foto 2]>>
<<End>>

[Sirotti]

This doesn't seem to work, either.

I've made a series of tries, and I have seen that when I use the unsliced datas I get the full list of values in the Database Foto table (but the images are shown as links), for example

<<Start:Veicoli[Foto]>>

Targa: <<Database foto[Targa/Telaio]>>

Foto 1: <<Database foto[Foto 1]>>

Foto 2: <<Database foto [Foto 2]>>

<<End>>

results in:

But whenever I use a slice (Veicoli personali or Foto Personali) the values disappear. 

I've read about using SELECT in START statements, but I couldn't figure out how they work, if someone would be so kind as to give me some pointers it would be much appreciated....

[Steve]

Let's start from the beginning again. Please post the following screenshots:

1) The configuration of the automation task that generates the PDF.

2) The template used to generate the PDF.

3) The configuration of the Foto column of the Veicoli table.