The height ot the cells, when exporting to Excel.
Hello!
I got a problem with the export from Reporting Services to Excel.
Look at the height of the cells. First cells had a very big height, comparing with others. I need that all the cells will be slim. This situation is in Excel. For example, when I'm doing export to PDF - all the cells are normal, slim.
Help me please with this problem!
June 14th, 2012 5:39am
Hi There
can you please check if there
is line feed or spaces with these first three four rows, please try to put trim function so that extra spaces get removed also check if there is any line feed in your data.
If you have any question please let me know.
Many Thanks
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful
Free Windows Admin Tool Kit Click here and download it now
June 14th, 2012 5:43am
Could you explane, what do you mean about checking the line feeds and spaces? There is not it cause in PDF all is normally.
And sorry, but I don't know how to run the trim function and where should I run it.
June 14th, 2012 6:03am
Hi There
In the first column and second column please try to put expression something like this inside your tablix column
=trim(replace(fields!columnA.value,chr(10),""))
=trim(replace(fields!columnA.value,chr(10),""))
you can do it for first columns and see if problem get resolved
If you have any question please let me know.
Many Thanks
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful
Free Windows Admin Tool Kit Click here and download it now
June 14th, 2012 6:22am
Hi There
In the first column and second column please try to put expression something like this inside your tablix column
=trim(replace(fields!columnA.value,chr(10),""))
=trim(replace(fields!columnA.value,chr(10),""))
you can do it for first columns and see if problem get resolved
If you have any question please let me know.
Many Thanks
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful
June 14th, 2012 6:27am
And where exactly should I put this expression?
If putting in a textboxes, how can I save the text there, cause when I'm entering the expression, the text in the textbox disappear.
Free Windows Admin Tool Kit Click here and download it now
June 14th, 2012 8:12am
I tried to turn down the check at Tex tBox Properties - Sizing Options - Allow height to increase
And cells "swallowing" the lines.
June 14th, 2012 9:31am