Report Template reference tables dont like my table?

Hello,

I have multiple tables that reference a column on one table.

These reference tables create tables in the attachment template by default:

1.jpeg

This table does exactly what it is supposed. (Side question. No idea why it only displays 5 columns when the table has many more?)

But when I reformat it like this:

2.jpeg

 It breaks like this:

  • Error 1 : 'Email Quote' task 'Sending Quote' Attachment template. Expression '[Bore Dia @ Gland]' is invalid due to: Unable to find column 'Bore Dia @ Gland'.
  • Error 2 : 'Email Quote' task 'Sending Quote' Attachment template. Expression '[Gland OD Dia]' is invalid due to: Unable to find column 'Gland OD Dia'...........

This goes on for every column. Note that the initial column of "Bore Dia @ Piston" seems to have processed correctly?

 

No idea why it fails. I used the same start expression. The end expression is located after the last column contents

Solved Solved
0 1 69
1 ACCEPTED SOLUTION

You may want to try the below format

Template Report-1.png

Also not sure why you mention there can be only 5 columns in the horizontal format, the below report has 6 columns

Suvrutt_Gurjar_0-1653655184100.png

The corresponding template is as follows

 

Suvrutt_Gurjar_2-1653655421029.png

 

View solution in original post

1 REPLY 1

You may want to try the below format

Template Report-1.png

Also not sure why you mention there can be only 5 columns in the horizontal format, the below report has 6 columns

Suvrutt_Gurjar_0-1653655184100.png

The corresponding template is as follows

 

Suvrutt_Gurjar_2-1653655421029.png

 

Top Labels in this Space