Paginated reports: auto width for columns in a table

[akhaliq7]

When I create a table in a painated report the column widths instead of spreading out horizontally continue on the next line. Is there a way to have a auto width feature that can fix this as currently what I am doing is using the auto width feature in excel than multiplying that by 2 and using that value in my paginated report but when you have 120 columns then it is not feasible would be easier if this was automated.

[Anonymous · Accepted solution]

Hey I am not sure paginate report auto column width setting, but in table/matrix visual, we can auto column width by certian width using measure. 
This is paginate report width change doc:
https://docs.microsoft.com/en-us/sql/reporting-services/report-design/change-row-height-or-column-wi...
Below is auto setting equal column with for matirix table:
https://www.youtube.com/watch?v=WCaFGO_AyDs

Hope there 2 links could give you some ideas, Cheers!