Missing header details with Render tool and column adjustment

I was using the Render tool to output 3 sheets into a single excel file.

I have a few questions:

(1) For Sheet 1, I am not sure why there are missing details for the headers. Eg. "Bill to Country (2)" becomes "Bill to Coun (2)".

(2) For Sheet 2, I am not sure column B is so wide.

If there anything wrong with my configuration?

Also, for "Table width" / "Layout width", is there a difference between automatic and percentage?

I have attached some screenshots for reference as well.

Any help is appreciated. Thanks!

Partial workflow and screenshots.docx

Workflow

Output

Accepted answers

ShankerV

Hi @Vanessa_JWS

Thanks for sharing the partial workflow, it helps to some extent to solve the issue 2.

I have amended the workflow.

Removed this block until done and created as single render tool.

Added the below for Sheet 2 to have less column size.

Kindly check and let me know if it works.

Many thanks

Shanker V

New Workflow3.yxmd

All comments

DataNath

Hey @Vanessa_JWS, you'll likely want to play around with the Paper Size in your Render tool.

When it comes to Fixed vs Automatic, this is in relation to that. I.e. if you Fix a table at 5 inches by 5 inches, it'll only ever be that big, even if your paper size is enormous. Whereas, if you use percentage i.e. 50%, the table will always be 50% of the width of the paper size. Here's a quick example:

(Table is fixed at 50% width) - Render Paper Size is 10x10in:

Increasing Render Paper Size to 20x10in, maintaining 50% width:

Width is Fixed to 7 inches, Render Paper Size = 10x10in:

Render Paper Size increased to 20x10 in, Fixed width remains at 7 inches:

The truncation often comes from your Paper Size being too small so the field names get squished like in your [Bill to Country (2)] field. Like so:

Big enough Paper Size for the field names to be on one line:

Slightly smaller Paper Size - text becomes wrapped to fit field names:

Paper Size reduced even further - truncation begins (and you even get orange warnings):

Playing around with the width settings in the table tool, as well as finding a suitable paper size in the final render ought to remedy your issue and result in a report that you're happy with!

ShankerV

Hi @Vanessa_JWS

Please be informed that, you are facing the issue 1 as below.

> In your Render tool, you might have the default Paper Size as Letter.

But you have many columns to project in the Sheet1 and hence few headers are looking like missing details.

Eg. "Bill to Country (2)" becomes "Bill to Coun (2)".

However, it is only the display issue but you can see the full header details if you click on the Specific cell.

In the top cell, we can see the full header details, but in the virtual display in the cell the header looks like truncated.

Solution for 1:

Request to increase the Size by using Custom Size.

This will help to resolve the issue. You can select 14, 17, or even 20 based on your requirement.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

ShankerV

Hi @Vanessa_JWS

Solution for 2:

You have only 2 columns displayed in Sheet2, but still the same default paper size letter is selected.

Hence both columns are spread across the full paper size 8.5" x 11" making the columns are very huge spread.

To overcome this issue, you need to again select Custom size and make 3" x 3" so that you can get the desired output.

Before:

After:

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Vanessa_JWS

Thanks @DataNath ! I will try to play around with the Paper size and see if this resolves my issue!

Vanessa_JWS

Hi @ShankerV

This doesn't seem like just a display issue as the full text is not appearing in the top cell as well.

Am I missing something? Thanks

ShankerV

Hi @Vanessa_JWS

Now you will encounter the issue, where you are trying to render all 3 sheets in using same Render tool.

Changing one paper size will affect all the 3 sheets.

To overcome this issue, you can render all 3 sheets into same excel sheet with Block Until Done tool.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

ShankerV

Hi @Vanessa_JWS

To use Block Until done for morethan 3 outputs.

You can replicate if the number increases.

Many thanks

Shanker

ShankerV

Hi @Vanessa_JWS

For the highlighted, (2) For Sheet 2, I am not sure column B is so wide.

Please find the below workaround.

Sheet2 with Decreased Column Size:

Sheet1:

The highlighted tools in yellow are added in addition to decrease the size of the column in sheet2 render output.

Please do add in your workflow and let me know if works.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Decresing column size for Vanessa_JWS.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703