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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics