May 12, 2014 at 8:00 am
I spent many hours trying to find a solution to this. The most recent answer I could find was 5 years old. I am hoping this community will either have an answer or confirm that this is "as designed".
My problem is that I have a Comments row (merged cells) as a second detail row in a tablix. When exporting to Excel, it does not honor the CanGrow option in SSRS. In other words, in Excel the row does not AutoFit and makes the report pretty useless.
So, I am hoping that “Unfortunately it's up to Excel how it handles AutoSize rows” Is not still the final answer.
Any ideas???
May 12, 2014 at 10:30 am
Pretty sure you are stuck. I'm not sure how SSRS would tell Excel the size that column needs to be for each row.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 12, 2014 at 10:44 am
Set CanGrow to false and explicity set the row height. Worked for me!
May 13, 2014 at 7:50 am
Thanks for the tips. It won't work in my situation because the row height varies greatly and the end users will not want to see huge blank rows to accommodate the comments that are verbose.
It also will help when I explain to my boss that it can't be done.
Thanks!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply