Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Adjust column widths in Excel output.
YSrinivas
<p>Hi,</p>
<p> </p>
<p><span style="color:#404040;"><span style="font-family:arial, sans-serif;"><span style="font-size:10pt;">Can we determine that for Excel based reports in Actuate we can set column widths in advance.</span></span></span></p>
<p> </p>
<p><span style="color:#404040;"><span style="font-family:arial, sans-serif;"><span style="font-size:10pt;">I have 15 columns, while exporting i see column width is adjusted to automatically to a minimum width. </span></span></span></p>
<p> </p>
<p><span style="font-size:13.3333330154419px;">Quick response is much appreciated.</span></p>
<p> </p>
<p><span style="font-size:13.3333330154419px;">Thanks</span></p>
<p><span style="font-size:13.3333330154419px;">Srinivas </span></p>
Find more posts tagged with
Comments
YSrinivas
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Hi,</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"><span style="color:rgb(64,64,64);"><span style="font-family:arial, sans-serif;"><span style="font-size:10pt;">Can we determine that for Excel based reports in Actuate we can set column widths in advance.</span></span></span></p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"><span style="color:rgb(64,64,64);"><span style="font-family:arial, sans-serif;"><span style="font-size:10pt;">I have 15 columns, while exporting i see column width is adjusted to automatically to a minimum width. </span></span></span></p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"><span style="font-size:13.3333330154419px;">Quick response is much appreciated.</span></p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"><span style="color:rgb(34,34,34);font-family:'Helvetica Neue', Arial, Verdana, sans-serif;">Eclipse BIRT Designer Version 4.2.3.v20131216-0430 Build <4.2.3.v20131216-0430></span></p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"><span style="font-size:13.3333330154419px;">Thanks</span></p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"><span style="font-size:13.3333330154419px;">Srinivas </span></p>
JFreeman
<p>Can you attach a sample report we can run that demonstrates the issue?</p>
YSrinivas
<p>Hi,</p>
<p>Thank you for your reply.</p>
<p> </p>
<p>Please find the attached excel file. Top left logo has been removed because of data security reasons.</p>
<p> </p>
<p>Your help will be much appreciated. Please could you help asap.</p>
<p> </p>
<p>Thanks</p>
<p>Srinivas Y</p>
YSrinivas
<p>Hi,</p>
<p> </p>
<p>Please could you let me know if there is a way to fix the issue?</p>
<p> </p>
<p>thanks</p>
<p>Srinivas</p>
YSrinivas
<p>Hi,</p>
<p> </p>
<p>Please find the report template, i have remove logo on top left else every thing remains same.</p>
<p> </p>
<p>Thanks</p>
<p>Srinivas</p>
newscott
<p>Hi </p>
<p> </p>
<p> Please try this</p>
<p> </p>
<p> 1.Add 15 columns and 7 rows in grid and specify width for each column.(as per your design above). Specify width for each column based on your table's data.</p>
<p> 2.Merge 1st row fully in grid and paste there your "Investigator List by Indication " grid.</p>
<p> 3.Merge next three rows fully and paste your second grid.</p>
<p> 4.Merge last three rows fully and paste your selectList grid.</p>
<p> </p>
<p>By this, your data will get adjusted according to width set by you.So you can change it as by your data.</p>
<p> </p>
<p>NOTE: Make sure you give same width for all grid and table including (15*7)grid which i mentioned in first point.</p>
<p> </p>
<p>Thanks,</p>
<p>newscott.</p>