Hi All,
Few days back we faced a problem when we were doing an Export to Excel of a report which was using sub-reports. After going thro. the knowledge base articles we came to know that SSRS currently doesn't suppot this option, an alternate is to use use List instead of tables, so we used List and did all the formatting with the list and the data was displayed correctly and it was Exporting to Excel also properly. But now we found out that after doing an Export to Excel, the Excel File is leaving blank rows between the data (i.e.,) If the report consists of two rows, then it displays the first row in the 10th row of excel and the second row in the 12th row of excel. The 11th row is blank and it appears as a small blank row between 10 and 12. The actual problem because of this is we are not able to do Auto filter in Excel, because Excel by default considers the values only until it encounters a blank row when we are doing auto filter. So is there a way to avoid this blank row while exporting to Excel, we have tried to remove the borders and all other stuffs but nothing seems to work. Have anyone encountered the same problem or is there any work around for this problem. Thanks in advance.
Have you tried removing padding for all the textboxes in your row in the list?
|||We have removed all the padding for the textboxes but still the same problem is coming. The moment we add the subreport this is happening, until then it is fine.
Note: The sub reports are placed in a list inside another list.
|||Maybe your subreport is still visible but with no data. Try hiding it based on some condition.
Also make sure that you dont have any gap vertically between all objects (textboxes, list, subreport etc) in your designer.
Shyam
No comments:
Post a Comment