Hi,
My Reports use a table to list the column headers, another table is used to essentially print each row that follows the row filter condition in the slice. When the report does this the table column width is modified depending on the cell value width, so large contents extend the column width in the row and affect the format of the table.
Is there any way to prevent this. Possibly lock the column width to a specified value?
Solved! Go to Solution.
Modify your table so there will be two rowsโฆ header and data row. In cell R2C1 write likeโฆ
<<Start: Select(Lang Lang Today[Timestamp],TRUE)>><<[Task]>>. In the last column in that table and in row 2, type it like <<[User]>><> if the โUserโ column is your last column.
Iโm afraid you canโt lock columnโs width. You have those 3 options "Default, Narrow and Wide view by view. Though you could also try to Save & Verify if it would adjust the column widths better.
@Aleksi
Iโm not sure we are thinking of the same thing.
Here is a screencap of the Report that was emailed via an attachment.
You can see how the columns are uneven and the table is not one causing border pixel issues.
I would just like to email a professional looking report.
No we didnโt
The reason is that you are not using Start & End expression. You are generating table after tabel and then the column width is never exactly the same.
Thereโs a start and end expression used, because appsheet created the file. Iโm unsure how to modify it though.
Yeah it definitely prints every row in a seperate table. Is there anyway we can put it in one table. The number of rows and contents would change on every report.
Modify your table so there will be two rowsโฆ header and data row. In cell R2C1 write likeโฆ
<<Start: Select(Lang Lang Today[Timestamp],TRUE)>><<[Task]>>. In the last column in that table and in row 2, type it like <<[User]>><> if the โUserโ column is your last column.
It is no longer sending the email, I assume I have made a mistake but I cant work out where. The only change I made was the tables are now combined, the start code is in the table, the comments has the <> after it and I have removed the <> in an attempt to figure out why itโs not working.
In Comments try this: <<[Comments]>><<End>>
Yeah it already is like that, out of curiosity what does the <> do? define the end?
Thatโs funny. If you Post <<[Comments]>><<End>>
, the output will be <<[Comments]>><>
@Peter
@SKETCHwade what you need is <<[Comments]>><<End>>
Youโre welcome
Aleksi, my template works fine but it gives me the list without any order. I would like to sort it by GRUPA (first column). How to use ORDERBY expression in a such template?
See topic โControlling Record Orderโ in this article https://help.appsheet.com/en/articles/961746-template-start-expressions
Thank you. Iโve read, and applied correct expression OrderBy. It works.
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
13 |