How Can I make sure the data displayed correctly in report template?

[nurhamizah_hamz]

Hi Appsheet community,

I do have some problem to display data in my report template.

This is my expression for the template .

basically all the data is in the same table . but the data won’t retrieved except for the first column and last column.

the weird thing is, the data in last column is displayed in the first column. refer the image below.

How can it become like this? Does anyone know how to solve this ?

[WillowMobileSys]

In your image you have the value [Service centre (Barang yang dihantar ke service centre - 1 barang 1 entry)] after the Start. Is this a table?

[nurhamizah_hamz]

this is actually a virtual column name from “Detail” table that i used to store data to “service centre” table. as the formula for the table = REF_ROWS(“Service centre”, “ID”)

Since i want to display the data from “service centre” table, i need to use the column in “Detail” table as “Detail” table is my source.

[Phil]

Your image of the template depicts the first 6 columns on one row and that last 3 columns on a second row. I presume that is simply a matter of how it is being displayed here, and that all 9 columns are actually side by side. Can you confirm that?

[nurhamizah_hamz]

yeah. in database, the columns is actually side by side. but in the template, i create a new table for the last 3 column.

is this affect on how i use the expression?

or do i need to put the End at the last column on first row and do the Start expression again on the second row ?

i actually did that but the data won’t be displayed …

[WillowMobileSys]

I can’t see anything wrong. I am including a sample from one of my templates that is very similar to what you have. The only real difference I am seeing is the structure of the START/END statement. My START is before the template table, while the END is after the template table. I have several templates using this same structure.

NOTE: I normally have the table grid lines “off” in my template. I am showing them here just for clarity.

I would try playing with format of the statement to see if it helps.

[nurhamizah_hamz]

Oh, is that so? i need to try it first to see the results. if I do face the same problem again, i will come back to you…

[Phil]

You wrote: “but in the template, i create a new table for the last 3 column.”

That approach will not work.

When you specify a table containing a Start expression and an End expression, the Start expression should be in the leftmost cell of the row and the End expression should be in the rightmost cell of the row. This indicates that the entire row should be repeated for each record returned by the Start expression.

If you put the Start expression inside one row and the End Expression inside a different row, we will not match the Start and End expressions.

The approach John is suggesting works because the Start and End will match when both are outside the row.

[nurhamizah_hamz]

So, the solution is that i need to put the Start and End expression outside the column ? i will try it first and if i do face any problem i will get back to you guys…