I have a master report with several subreports, each in its own detail section, and each on a different Excel sheet. It seems that when exported as Excel, if the column widths in each subreport do not match exactly, then the columns are all weird, with some merged and some hidden. Each subreport takes one Excel column per report column when run seprately.
Seems like if the sub reports are on different sheets, then each should be able to have different column widths. Is there a wa to do this?