Blank rows in Export To Excel

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

blank pages inserted on exported pdf and tif format

Hi,
After I export the report to PDF or TIF format, the pages became double. It
inserts a blank sheet on every page of the report. Does anyone know how to
fix this issue? Any help is appreciate it.
Thanks,
LianneLianne,
I had that problem too. Some of your report items are wider than the page.
Look on the ruler above your report page and make sure that you do not have
any report items that go to the right more than the width of your page
(usually it's 8.5 inches).
Good luck.
"Lianne Kwock" wrote:
> Hi,
> After I export the report to PDF or TIF format, the pages became double. It
> inserts a blank sheet on every page of the report. Does anyone know how to
> fix this issue? Any help is appreciate it.
>
> Thanks,
> Lianne|||Not greater than the width of the page when considering your margins plus
the ruler.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Simon Gold" <SimonGold@.discussions.microsoft.com> wrote in message
news:862C6173-C1F9-40B2-8C4E-1B1333BEA0ED@.microsoft.com...
> Lianne,
> I had that problem too. Some of your report items are wider than the page.
> Look on the ruler above your report page and make sure that you do not
> have
> any report items that go to the right more than the width of your page
> (usually it's 8.5 inches).
> Good luck.
> "Lianne Kwock" wrote:
>> Hi,
>> After I export the report to PDF or TIF format, the pages became double.
>> It
>> inserts a blank sheet on every page of the report. Does anyone know how
>> to
>> fix this issue? Any help is appreciate it.
>>
>> Thanks,
>> Lianne|||You will also need to make sure that your report respect the following:
Body:Width > (Report:PageWidth - Report:LeftMargin -
Report:RightMargin).
A similar restriction exists for Body:Height and Report:PageHeight.
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lianne Kwock" <LianneKwock@.discussions.microsoft.com> wrote in message
news:509E186D-CBBD-4725-B46C-47F175AEAA6F@.microsoft.com...
> Hi,
> After I export the report to PDF or TIF format, the pages became double.
> It
> inserts a blank sheet on every page of the report. Does anyone know how
> to
> fix this issue? Any help is appreciate it.
>
> Thanks,
> Lianne

blank pages in reports through subscriptions

I have Reporting Services 2005 wsp1, SQL Server 2005 version 9.00.2047. When
I generate reports through Reports Admin interface and then export them to
PDF, they come out ok. When I set up a subscription that is supposed to send
a report in pdf format - I get the same report with around 50 blank pages
inserted in it.
Anybody ran across the same stuff?On Mar 2, 11:39 am, "ilona" <ilona_scramb...@.no-go.com> wrote:
> I have Reporting Services 2005 wsp1, SQL Server 2005 version 9.00.2047. When
> I generate reports through Reports Admin interface and then export them to
> PDF, they come out ok. When I set up a subscription that is supposed to send
> a report in pdf format - I get the same report with around 50 blank pages
> inserted in it.
> Anybody ran across the same stuff?
I've had some problems with this before...I would try to eliminate any
unused space in the report designer area and check your page
setting...
Cheers,
-Ben

blank page in pdf report

When I export my report to PDF, I get a blank page that shows up. The
header and footer are on the second page, but the body is blank. There
isn't enough data for a second page. Why is one being created? Any ideas?Most likely, something in your footer is touching one or more of your
margins. Make sure everything is inside the margins and you should be
good.

Blank Page Between Exported Report

For some reason when I export the report from the web interface it exports
with an extra page between each page - it looks as if it has set the tables
that are in the report to 100% and then added an extra page because it
overflowed. However, this does not occur when I export from the Report
Manager or from the report Toolkit IDE.
Any ideas?
MikeTake a look at the previous post on this:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=4da98d7c-af5a-45c0-8cdf-dad47c6cb771
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Solomons" <mikesolo@.optonline.net> wrote in message
news:uVWw5ZKdEHA.1040@.TK2MSFTNGP10.phx.gbl...
> For some reason when I export the report from the web interface it exports
> with an extra page between each page - it looks as if it has set the
tables
> that are in the report to 100% and then added an extra page because it
> overflowed. However, this does not occur when I export from the Report
> Manager or from the report Toolkit IDE.
> Any ideas?
> Mike
>|||That didn't solve my problem - it's really odd - like I said in the IDE when
I export to PDF it fits fine, but when I use the Report Viewer ASP.NET
component from the web it adds an extra space - it also looks like the table
has been set to strectch 100% or something - any other ideas?
Mike
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:ulG1p0KdEHA.2268@.TK2MSFTNGP12.phx.gbl...
> Take a look at the previous post on this:
>
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=4da98d7c-af5a-45c0-8cdf-dad47c6cb771
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Michael Solomons" <mikesolo@.optonline.net> wrote in message
> news:uVWw5ZKdEHA.1040@.TK2MSFTNGP10.phx.gbl...
> > For some reason when I export the report from the web interface it
exports
> > with an extra page between each page - it looks as if it has set the
> tables
> > that are in the report to 100% and then added an extra page because it
> > overflowed. However, this does not occur when I export from the Report
> > Manager or from the report Toolkit IDE.
> >
> > Any ideas?
> >
> > Mike
> >
> >
>|||Encountered a similar problem where;
"Report Properties, Layout, Page width=8.5 Page height=11"
and
"Body Properties, Size, width=8.5, height=11"
Exported PDF's printed extra pages. After trying near everthing I could
think of I changed the height as follows;
"Body Properties, Size, width=8.5, height=10.99"
After that everything worked just fine.
Go figure, but it worked.
HTH,
Greg|||Nope - didn't work - anothe rodd thing though - I have an image which is
psuhed to the furthemost right side of the report - in the design view, it
is the item which is right most - when publish to the web and view it in the
report viewer, it is stilll all the way to the right, but the table seems to
go much further - as if that is the problem.
Also - keep in mind this isn't happening when I export to PDF from the
Report Manager interface, only when I export from the report viewer ASP.net
component from our website.
Odd...
Mike
"Greg Rowland" <greg@.waveltd.com> wrote in message
news:%23PeuB0LdEHA.3664@.TK2MSFTNGP12.phx.gbl...
> Encountered a similar problem where;
> "Report Properties, Layout, Page width=8.5 Page height=11"
> and
> "Body Properties, Size, width=8.5, height=11"
> Exported PDF's printed extra pages. After trying near everthing I could
> think of I changed the height as follows;
> "Body Properties, Size, width=8.5, height=10.99"
> After that everything worked just fine.
> Go figure, but it worked.
> HTH,
> Greg
>|||You may want to try exporting to a PDF or other format, just see what it
looks like. You may get some other ideas from that.
Good luck,
G