Excel Export - Missing pages

I am using Excel as an export format but on some occasions only some
of the report pages are represented in the Excel output (1 page per
sheet). This doesn't happen for all exports but happens consistently
for a given set of report input parameters.
A PDF export of the same report seems fine.
Has anyone come across similar truncation of Excel exports?
TIA
SimonI am having same problem as well. Would appreciate any help !!
"Simon" wrote:
> I am using Excel as an export format but on some occasions only some
> of the report pages are represented in the Excel output (1 page per
> sheet). This doesn't happen for all exports but happens consistently
> for a given set of report input parameters.
> A PDF export of the same report seems fine.
> Has anyone come across similar truncation of Excel exports?
> TIA
> Simon
>

EXCEL Addin for AS - Training Document

I have installed it but the only document I can find on how to use are the
white paper (only 2-3 pages) plus the help file !!!
I do not know how to do for example connect 2 cubes into one single table.
Please can anyone help to advise where I can find some training document '
Thanks !!!Pls help...
"hkappleorange" <hkappleorange@.yahoo.com.hk> ¼¶¼g©ó¶l¥ó·s»D
:OxRHJEluFHA.1560@.TK2MSFTNGP09.phx.gbl...
> I have installed it but the only document I can find on how to use are the
> white paper (only 2-3 pages) plus the help file !!!
> I do not know how to do for example connect 2 cubes into one single table.
> Please can anyone help to advise where I can find some training document
'
> Thanks !!!
>sql

Excel "Saved as Web Page" import

I am trying to import spreadsheets from web pages on a regular basis. I do not have any control over their format but they have all been saved as web pages from Excel.

There are two parts to this:
a) Downloading the files
b) Importing the downloads

Right now I am focusing on b) Importing the downloads.

I have tried
1) Using an Excel connection in DTS
2) Using OPENROWSET to access the spreadsheets more directly from TSQL
3) Using a linked server to the file.

All of these seem to use the OLEDB 4.0 provider and they all work if I convert the *.htm file to a *.xls file using Excel first.

With one curious exception none of them work from the *.htm files. DTS is the exception, if I first open the *.htm files in Excel the transformation task succeeds.

I don't really want to use Excel at all on the server. It's strange that DTS does work when the *.htm file is open.

I am trying to get some insight into the various OLEDB options to use hoping that will help me avoid having to use Excel. Perhaps I would just be better off using SQL Server 2005 and SSIS?A couple of things here, Oliver.

First, Excel exported to HTML isn't a valuable format when it comes to being able to import off of that data. Why even export it at all when you can just hook into the raw Excel file?

Secondly, if you want to use SSIS, we can help you with that, though I'm not sure that loading an Excel generated HTML file will work. If you are going to stick with DTS, then you should ask this on the forum for that tool: http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg&hl=en|||Phil, thanks for the reply but as I mentioned the files are in html and I cannot change that.

Has anyone here used SSIS with an html formatted Excel file?

Ian.|||Best of luck with that! I'd work on getting a new format, 'cause you're going to have to write your own script, or scour the Internet for a custom module already built. There isn't an HTML source in SSIS, nor should there be, in my opinion. It's not really suitable for data transmission.sql

everything on one page

Hi,
In my reports i usually have 1 tabel. Now, when i run my report, all of my
data (wich can be quite large) is spread out over serveral pages (you can see
on top 'page 1 of 15' eg). Is there a way i can put everything on one page
(so i get page 1 of 1). It doens't matter that it's not overlookable, but for
my application, it's really necessary
THx
KoenThat depends on what you want to show. If you want all this data to show on
the report, then the only option is to make the font so small as to be
unreadable. If you only want the "upper levels", then right click all the
fields, go into properties, hit "advanced" and click on the visibility tab.
Click "Hidden", "visibility can be toggled", select the levels that can
toggle visibility. Then highlight the entire Details line of your table
(assuming you're working from a table and not a Matrix, List or blank form).
Click on the properties screen and change it's visibility to Hidden and
change the ToggleItem property to the same field as the other fields. This
will "fill up" the white space when everything is collapsed with the upper
levels close to each other. Once you expand things, it'll start taking up
space again.
Hope that helps you out.
Catadmin
"Koen" wrote:
> Hi,
> In my reports i usually have 1 tabel. Now, when i run my report, all of my
> data (wich can be quite large) is spread out over serveral pages (you can see
> on top 'page 1 of 15' eg). Is there a way i can put everything on one page
> (so i get page 1 of 1). It doens't matter that it's not overlookable, but for
> my application, it's really necessary
>
> THx
> Koen|||"=?Utf-8?B?S29lbg==?=" <Koen@.discussions.microsoft.com> wrote in
news:9F5E3050-C7CE-419C-A8C6-E910C46EC2CE@.microsoft.com:
> Hi,
> In my reports i usually have 1 tabel. Now, when i run my report, all
> of my data (wich can be quite large) is spread out over serveral pages
> (you can see on top 'page 1 of 15' eg). Is there a way i can put
> everything on one page (so i get page 1 of 1). It doens't matter that
> it's not overlookable, but for my application, it's really necessary
>
> THx
> Koen
I just posted a note about a similar, but opposite problem. If I use any
expression for visibility/hidden on the table I get one page in html rather
than the dozens I expect. So for fun you can try setting visibility/hidden
on the table to an expression that merely says "=False"... though I
wouldn't exploit what I think is a bug.
J.

every other printed page blank?

I made a report, put a header, footer and a table on it with data, when in
report view it shows up as 24 pages.. when in print view it shows up as 60
pages with every other one blank but containing a header and footer only?
what would cause this? page size, margins, anything like that? thanks!Check the page size on your currently selected printer and the border sizes
Check the width of the report - it should be less than (page width - left
border - right border)
HTH,
Andrei.
"Smokey Grindle" <nospam@.dontspamme.com> wrote in message
news:OBudLkNOHHA.420@.TK2MSFTNGP06.phx.gbl...
>I made a report, put a header, footer and a table on it with data, when in
>report view it shows up as 24 pages.. when in print view it shows up as 60
>pages with every other one blank but containing a header and footer only?
>what would cause this? page size, margins, anything like that? thanks!
>|||got it thanks! It was the "report" size that was too large for the page size
+ margins
"Andrei" <andrei.toma@.era-environmental.com> wrote in message
news:eCEqEsNOHHA.1248@.TK2MSFTNGP03.phx.gbl...
> Check the page size on your currently selected printer and the border
> sizes
> Check the width of the report - it should be less than (page width - left
> border - right border)
> HTH,
> Andrei.
> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
> news:OBudLkNOHHA.420@.TK2MSFTNGP06.phx.gbl...
>>I made a report, put a header, footer and a table on it with data, when in
>>report view it shows up as 24 pages.. when in print view it shows up as 60
>>pages with every other one blank but containing a header and footer only?
>>what would cause this? page size, margins, anything like that? thanks!
>

Every other page is blank when saving .PDF in SSRS

I'm using SSRS web service to generate a report and saving it to a .pdf file. The number of pages in the report is always doubled because every other page is blank. Anyone come accross this issue?

When I save the report as an excel file everything is fine.

Thank in advance,

I found it was the Body, Page Header or Footer field contents not accounting for margins. So if the Report size value is (8.5,11in) or (11,8.5in), check your textboxes, tables layout fields and Body parts to ensure the margin is accounted for in the size. I usually use a max of 10.5 for by landscape reports.|||

shview:

I found it was the Body, Page Header or Footer field contents not accounting for margins. So if the Report size value is (8.5,11in) or (11,8.5in), check your textboxes, tables layout fields and Body parts to ensure the margin is accounted for in the size. I usually use a max of 10.5 for by landscape reports.

You're correct. I figured that out after I made the post. Thanks for your feedback.

Even not pages printing in Reporting Services

After creating and deploying a new report I try printing but it will not print on even pages. I'm using SQLServer 2005. It prints page 1 then only header and footer on page2 then page 3 has the continuation from page 1, etc...

Any ideas?

good day..

i have encounter same problem with you. but i resolve it by proper page breaks. try to page break end in the footer.

|||

Most likely your report definition (report.body + margin left + margin right) is wider than the page width. Hence, every second page is an empty page.

You may also want to read this blog posting: http://blogs.msdn.com/bwelcker/archive/2005/08/19/454043.aspx

-- Robert