Adjust column widths in Excel output.

Hi,
 
Can we determine that for Excel based reports in Actuate we can set column widths in advance.
 
I have 15 columns, while exporting i see column width is adjusted to automatically to a minimum width. 
 
Quick response is much appreciated.
 
Thanks
Srinivas

Find more posts tagged with

Comments

YSrinivas

Hi,
 
Can we determine that for Excel based reports in Actuate we can set column widths in advance.
 
I have 15 columns, while exporting i see column width is adjusted to automatically to a minimum width. 
 
Quick response is much appreciated.
 
Eclipse BIRT Designer Version 4.2.3.v20131216-0430 Build <4.2.3.v20131216-0430>
 
Thanks
Srinivas

JFreeman

Can you attach a sample report we can run that demonstrates the issue?

YSrinivas

Hi,
Thank you for your reply.
 
Please find the attached excel file. Top left logo has been removed because of data security reasons.
 
Your help will be much appreciated. Please could you help asap.
 
Thanks
Srinivas Y

YSrinivas

Hi,
 
Please could you let me know if there is a way to fix the issue?
 
thanks
Srinivas

YSrinivas

Hi,
 
Please find the report template, i have remove logo on top left else every thing remains same.
 
Thanks
Srinivas

newscott

Hi 
 
 Please try this
 
 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.
 2.Merge 1st row fully in grid and paste there your "Investigator List by Indication " grid.
 3.Merge next three rows fully and paste your second grid.
 4.Merge last three rows fully and paste your selectList grid.
 
By this, your data will get adjusted according to width set by you.So you can change it as by your data.
 
NOTE: Make sure you give same width for all grid and table including (15*7)grid which i mentioned in first point.
 
Thanks,
newscott.