Exporting reports to Excel

Hi everybody:
I created a report and I exported it to Excel.
My report has a chart that is set to "no visible", exporting it to PDF I
have no problems, but exporting it to MSExcel, I can see the chart!!!!
Is this a bug? Is there any workaround to allow me to export to both PDF and
Excel?
Best regards
ErnestoDo you have conditional visibility on the chart?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
news:eDi8KwtkEHA.3720@.TK2MSFTNGP12.phx.gbl...
> Hi everybody:
> I created a report and I exported it to Excel.
> My report has a chart that is set to "no visible", exporting it to PDF I
> have no problems, but exporting it to MSExcel, I can see the chart!!!!
> Is this a bug? Is there any workaround to allow me to export to both PDF
> and
> Excel?
> Best regards
>
> Ernesto
>|||Yes, I have some like
Hidden
=IIF(fields!Name="Name", true, false)
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:ufXtiD7kEHA.3536@.TK2MSFTNGP12.phx.gbl...
> Do you have conditional visibility on the chart?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
> news:eDi8KwtkEHA.3720@.TK2MSFTNGP12.phx.gbl...
> > Hi everybody:
> >
> > I created a report and I exported it to Excel.
> >
> > My report has a chart that is set to "no visible", exporting it to PDF I
> > have no problems, but exporting it to MSExcel, I can see the chart!!!!
> >
> > Is this a bug? Is there any workaround to allow me to export to both PDF
> > and
> > Excel?
> >
> > Best regards
> >
> >
> > Ernesto
> >
> >
>|||Are you running SP1? I think there was a fix around conditional visibility
in Excel.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
news:e9F0JOClEHA.536@.TK2MSFTNGP11.phx.gbl...
> Yes, I have some like
> Hidden
> =IIF(fields!Name="Name", true, false)
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:ufXtiD7kEHA.3536@.TK2MSFTNGP12.phx.gbl...
>> Do you have conditional visibility on the chart?
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Ernesto Bascón" <ebascon@.hotmail.com> wrote in message
>> news:eDi8KwtkEHA.3720@.TK2MSFTNGP12.phx.gbl...
>> > Hi everybody:
>> >
>> > I created a report and I exported it to Excel.
>> >
>> > My report has a chart that is set to "no visible", exporting it to PDF
>> > I
>> > have no problems, but exporting it to MSExcel, I can see the chart!!!!
>> >
>> > Is this a bug? Is there any workaround to allow me to export to both
>> > PDF
>> > and
>> > Excel?
>> >
>> > Best regards
>> >
>> >
>> > Ernesto
>> >
>> >
>>
>

Exporting Reports creates a blank window

I have created a few reports and linked them to a URL on a web page. (sample link is : http://servername/ReportServer/Pages/ReportViewer.aspx?%2fMy_Reports%2fBacklog+Report&rs:Command=Render )

When the user clicks on the link above it renders correctly but when the user tries to export the report to any format on the list, it launches another window with the following URL : http://servername/ReportServer/Reserved.ReportViewerWebControl.axd?ExecutionID=czq4c355dmsxdy55dif1nm55&ControlID=ad74d68e-2a9c-430f-8655-dd0e6c46f831&Culture=1033&UICulture=9&ReportStack=1&OpType=Export&FileName=Backlog+Report&ContentDisposition=OnlyHtmlInline&Format=EXCEL

which then prompts the user to Open or Save the report.

How do I stop this window from opening ? or how can I make it close automatically ?

Please advise.

I know if I can change the ContentDisposition somehow to AlwaysInline then this extra window will not show during the export but it keeps defaulting to OnlyHTMLInline for ContentDisposition.

Thanks in advance.

AL

Change ContentDispostion = AlwaysInline.|||

I had the same issue, which results from an IE hotfix that is applied to all the workstations at my work site. To get around this issue, I created a WEB project in Visual Studio 2005 and added in the ReportViewer web control. There is where you can overwrite the default setting for ExportContentDisposition. I changed to "AlwaysInline" to get around the problem.

Exporting Reports creates a blank window

I have created a few reports and linked them to a URL on a web page. (sample link is : http://servername/ReportServer/Pages/ReportViewer.aspx?%2fMy_Reports%2fBacklog+Report&rs:Command=Render )

When the user clicks on the link above it renders correctly but when the user tries to export the report to any format on the list, it launches another window with the following URL : http://servername/ReportServer/Reserved.ReportViewerWebControl.axd?ExecutionID=czq4c355dmsxdy55dif1nm55&ControlID=ad74d68e-2a9c-430f-8655-dd0e6c46f831&Culture=1033&UICulture=9&ReportStack=1&OpType=Export&FileName=Backlog+Report&ContentDisposition=OnlyHtmlInline&Format=EXCEL

which then prompts the user to Open or Save the report.

How do I stop this window from opening ? or how can I make it close automatically ?

Please advise.

I know if I can change the ContentDisposition somehow to AlwaysInline then this extra window will not show during the export but it keeps defaulting to OnlyHTMLInline for ContentDisposition.

Thanks in advance.

AL

Change ContentDispostion = AlwaysInline.|||

I had the same issue, which results from an IE hotfix that is applied to all the workstations at my work site. To get around this issue, I created a WEB project in Visual Studio 2005 and added in the ReportViewer web control. There is where you can overwrite the default setting for ExportContentDisposition. I changed to "AlwaysInline" to get around the problem.

Exporting Reports creates a blank window

I have created a few reports and linked them to a URL on a web page. (sample link is : http://servername/ReportServer/Pages/ReportViewer.aspx?%2fMy_Reports%2fBacklog+Report&rs:Command=Render )

When the user clicks on the link above it renders correctly but when the user tries to export the report to any format on the list, it launches another window with the following URL : http://servername/ReportServer/Reserved.ReportViewerWebControl.axd?ExecutionID=czq4c355dmsxdy55dif1nm55&ControlID=ad74d68e-2a9c-430f-8655-dd0e6c46f831&Culture=1033&UICulture=9&ReportStack=1&OpType=Export&FileName=Backlog+Report&ContentDisposition=OnlyHtmlInline&Format=EXCEL

which then prompts the user to Open or Save the report.

How do I stop this window from opening ? or how can I make it close automatically ?

Please advise.

I know if I can change the ContentDisposition somehow to AlwaysInline then this extra window will not show during the export but it keeps defaulting to OnlyHTMLInline for ContentDisposition.

Thanks in advance.

AL

Change ContentDispostion = AlwaysInline.|||

I had the same issue, which results from an IE hotfix that is applied to all the workstations at my work site. To get around this issue, I created a WEB project in Visual Studio 2005 and added in the ReportViewer web control. There is where you can overwrite the default setting for ExportContentDisposition. I changed to "AlwaysInline" to get around the problem.

Exporting PDF - Adding empty page

Hi,

I created a report using dynamic display( I hide the column using the expression in Property->Visibility).By using expression the column which is having null is hided.When I try to export the report to PDF,the empty pages are displaying along with data.Ie.,The report contyains only 5 pages but in PDF it is displaying 10 pages(5pages data with 5 empty pages).

Any Suggestions appreciated!

Thanks

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

|||

Chris Baldwin - MSFT wrote:

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

I am trying to accomplish the same thing and my problem is the Body width as mentioned by Chris.. it is too wide since my available set of columns is fairly large. Are there any known tricks to work around this limitation, using matrices, or whatever technique?

- Ron

Exporting PDF - Adding empty page

Hi,

I created a report using dynamic display( I hide the column using the expression in Property->Visibility).By using expression the column which is having null is hided.When I try to export the report to PDF,the empty pages are displaying along with data.Ie.,The report contyains only 5 pages but in PDF it is displaying 10 pages(5pages data with 5 empty pages).

Any Suggestions appreciated!

Thanks

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

|||

Chris Baldwin - MSFT wrote:

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

I am trying to accomplish the same thing and my problem is the Body width as mentioned by Chris.. it is too wide since my available set of columns is fairly large. Are there any known tricks to work around this limitation, using matrices, or whatever technique?

- Ron

Exporting MS SQL Server or Oracle Databases to MySQL

I also posted similarly in mailing.database.mysql

I have created a rather large (60 table database) website dealio in PHP that
works with MS SQL Server, Oracle, MySQL and presumably any other data base I
add to
the wrapper functions that I created. All the development was done in
Oracle, but now its time to create that large datastructure again in
MySQL -- now I've built this all in notepad for Oracle (twice) and built it
in SQL Server using the SQL Server import tools (pretty nice) -- is there
anything that I can do that to get this datastructure and maybe even the
data into MySQL using Oracle/MS SQL Server tools ?

James"James Alexander Starritt"
<jamesstarrittRemovethefollowingtoemailme@.hotmail.c om> wrote in message
news:403ac257_1@.newspeer2.tds.net...
> I also posted similarly in mailing.database.mysql
> I have created a rather large (60 table database) website dealio in PHP
that
> works with MS SQL Server, Oracle, MySQL and presumably any other data base
I
> add to
> the wrapper functions that I created. All the development was done in
> Oracle, but now its time to create that large datastructure again in
> MySQL -- now I've built this all in notepad for Oracle (twice) and built
it
> in SQL Server using the SQL Server import tools (pretty nice) -- is there
> anything that I can do that to get this datastructure and maybe even the
> data into MySQL using Oracle/MS SQL Server tools ?

SQL Server will permit the creation of scripts
for the data tables that should be useful, and the
bcp function should handle the data.

Pete Brown
Falls Creek
NSW
Oz
|||"James Alexander Starritt" <jamesstarrittRemovethefollowingtoemailme@.hotmail.c om> wrote in message news:<403ac257_1@.newspeer2.tds.net>...
> I also posted similarly in mailing.database.mysql
> I have created a rather large (60 table database) website dealio in PHP that
> works with MS SQL Server, Oracle, MySQL and presumably any other data base I
> add to
> the wrapper functions that I created. All the development was done in
> Oracle, but now its time to create that large datastructure again in
> MySQL -- now I've built this all in notepad for Oracle (twice) and built it
> in SQL Server using the SQL Server import tools (pretty nice) -- is there
> anything that I can do that to get this datastructure and maybe even the
> data into MySQL using Oracle/MS SQL Server tools ?
> James

From the MSSQL side, you could start by scripting the objects from
Enterprise Manager, then reviewing the code and making any
modifications needed to handle different data types, syntax etc. I
know nothing about MySQL, so I have no idea how large or small a task
this would be, except to guess that procedural code (stored
procedures, triggers, user-defined functions) may be the hardest part.
The resulting file can then be run in MySQL.

To move the data over, there are several different options. You can
use BCP or DTS to export to flat files, then import them into MySQL
using whatever tools it provides for bulk import. Alternatively, if
there is an ODBC driver for MySQL, you could use DTS to move the data
directly from MSSQL and/or Oracle to MySQL. Finally, you may be able
to create a linked server on MSSQL, then simply do an INSERT ...
SELECT ... to move the data.

Simon

Exporting from MSDE to SQL Server

Hi All,

I recently created my entire site before even starting to look at hosting providers. It's a very complex ASP.NET e-Commerce site built on SQL Server. I've (nearly) got it to a point where I want it to go live.

I found a host that caters for all my needs and is a good price. What I need to do now is migrate all my data, as well as all my tables and stored procedures, into the database with my host.

Is there an easy wy to go about this?

- Mina

I would install SQL Server backup your databases and restore it in SQL Server with same name if you use the restore from Device option in the backup wizard and SQL Server will move everything for you including permissions. Then moving to the host provider will be easy because SQL Sever Enterprise Manager is needed to move your databases with most Host Companies. Hope this helps.|||You need to talk to your hosting provider -- the easiest way toaccomplish this will be to simply send them the detached MDF and LDFfiles and have the provider attach them. Whether or not they'rewilling to do that is another question

Exporting Database for Importing on Another Server

This may be a simple question with an obvious answer, but I'm fairly new to databases and I can't seem to find the right procedure.

I created a database on my machine. If I want to copy the information from this database (columns, tables, and entries specifically) from my machine to another SQL server on a different machine, what is the best way to do this without manually re-entering all of the information?

Is there a simple export/import of a database for transferring it from one server to another?

Thanks,

~Josh Graber

Using Backup and Restore is often considered the 'best' way to move a database from one server to another.

Check in Books Online about using Restore with the [with MOVE] option.

|||

there are many method which u can use for this purpose....

(a) Backup/Restore

(b) Detach /attach

(c) copy database wizard

u can read about these method in BOL ...

Madhu

Exporting a table to Excel using bcl utility (Newbie)

I am trying to learn SQL 2005 Express and I am having a problem exporting (if that is the correct word) a table to Excel.

I have created a view in the Northwind database called MyCustomerView and want to practice working with the table.

From the command prompt:

bcp Northwind.dbo.MyCustomerView out MCV.xls -S -T

I then get the error message:

c:\> bcp Northwind.dbo.MyCustomerView out MCV.xls -S -T

SQLState = 08001, NativeError = 10061

Error = [Microsoft][SQL Native Client]TCP Provider: No connection could be made because the target machine actively refused it.

SQLState = HYT00, NativeError = 0

Error = [Microsoft][SQL Native Client]Login timeout expired

SQLState = 08001, NativeError = 10061

Error = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

This is on a single machine running Widows XP Home.

Help Please

Did you enable remote connections on the SQL Server express machine ? See the Screencast on my site for more information and a walkthrough. Do you have SQL Browser started ? SQL Server will pick a port to bind it to the service. If SQL Browser is not started you will have to specify it within the server declaration. If started it will directly redirect you to the appropiate instance.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks Jens

Everything you suggested I have tried, but am still getting the errors.

Exported Stored procedures

Hello and thanks to all of the helpers!
Especially for Linchi Shea for the Perl script.
When I compare the sql script created by the perl script (after little
modification on my side) with the one created by the MS GUI tool for
creating SQL scripts, I get the stored procedues on different order. When
running the script from SQL Query Analyzer, it displays errors (warnings?):
"Cannot add rows to sysdepends for the current stored procedure because it
depends on the missing object 'GUIRemoveEntity'. The stored procedure will
still be created."
I understand that the order of them DOES matter, but, if at the end of the
process, all of the SPs are loaded, will everything work?
Thanks!
RoeeIf the script is atomic (e.g. drops and re-creates the stored procedures),
running the script a second time should solve the problem.
sysdepends is generally unreliable anyway, and I typically ignore this
message unless I heavily rely on the feature and religiously make sure it is
correct.
A
"Roee Friedman" <necnecnecnec@.hotmail.com> wrote in message
news:bo5mfh$182orj$1@.ID-200860.news.uni-berlin.de...
> Hello and thanks to all of the helpers!
> Especially for Linchi Shea for the Perl script.
> When I compare the sql script created by the perl script (after little
> modification on my side) with the one created by the MS GUI tool for
> creating SQL scripts, I get the stored procedues on different order. When
> running the script from SQL Query Analyzer, it displays errors
(warnings?):
> "Cannot add rows to sysdepends for the current stored procedure because it
> depends on the missing object 'GUIRemoveEntity'. The stored procedure will
> still be created."
> I understand that the order of them DOES matter, but, if at the end of the
> process, all of the SPs are loaded, will everything work?
> Thanks!
> Roee
>|||Just a word of caution. if you run the script twice with
DROP PROC placed immediately before its respective CREATE
PROC, you won't see the error message. But it doesn't
solve the problem of dependency.
The best you can do with sysdepends is not to use it.
The only way to be sure of the dependency is to scan the
TSQL code and sort the depenency yourself. If you see
anybody claiming that his tool correctly handles the
procedure dependency, ask how he determines the
dependency. If it doesn't parse the code, don't believe it.
In addition, if someone claims that he has a pure TSQL
script that can sort the SP dependency correctly, don't
believe it either.
Rosee, I do have a Perl script that scan the SP code and
sort them by their dependency. Drop me an email if you are
interested.
Linchi
>--Original Message--
>If the script is atomic (e.g. drops and re-creates the
stored procedures),
>running the script a second time should solve the problem.
>sysdepends is generally unreliable anyway, and I
typically ignore this
>message unless I heavily rely on the feature and
religiously make sure it is
>correct.
>A
>
>"Roee Friedman" <necnecnecnec@.hotmail.com> wrote in
message
>news:bo5mfh$182orj$1@.ID-200860.news.uni-berlin.de...
>> Hello and thanks to all of the helpers!
>> Especially for Linchi Shea for the Perl script.
>> When I compare the sql script created by the perl
script (after little
>> modification on my side) with the one created by the MS
GUI tool for
>> creating SQL scripts, I get the stored procedues on
different order. When
>> running the script from SQL Query Analyzer, it displays
errors
>(warnings?):
>> "Cannot add rows to sysdepends for the current stored
procedure because it
>> depends on the missing object 'GUIRemoveEntity'. The
stored procedure will
>> still be created."
>> I understand that the order of them DOES matter, but,
if at the end of the
>> process, all of the SPs are loaded, will everything
work?
>> Thanks!
>> Roee
>>
>
>.
>|||> The only way to be sure of the dependency is to scan the
> TSQL code and sort the depenency yourself.
Agreed.
> Rosee, I do have a Perl script that scan the SP code and
> sort them by their dependency.
I'm sure this could be done in T-SQL as well... maybe an interesting
exercise if I get bored. :-)|||Aaron;
Do you want to bet two beers at PASS2003 (if you are
going) that if a robust SP dependency sort program is done
in TSQL, it would be so ugly that it's practically
undoable? Ugliness is of course a matter of opinion and
lies the eyes of the the beholder :-)
I have no doubt you can do it in TSQL or any other
language that supports varibles, some string functions,
and the basic set of control flow constructs.
One of the major problems of doing this in TSQL is that
you need true recursion, which you can simulate with TSQL,
but rather unsightly. By 'robust', I mean it has to deal
with all the nuances.
Linchi
>--Original Message--
>> The only way to be sure of the dependency is to scan the
>> TSQL code and sort the depenency yourself.
>Agreed.
>> Rosee, I do have a Perl script that scan the SP code and
>> sort them by their dependency.
>I'm sure this could be done in T-SQL as well... maybe an
interesting
>exercise if I get bored. :-)
>
>.
>sql

export with a webservice

Hi,
I have created an application with VIsual Studio.NET in C#. I used a
webservice in order to view my reports.
I want export my report in format that I want with this application.
How can I do? What is the solution?I've done this by putting into a dropdownlist the available export formats
for a particular report. then when i go to render the report i have the
following code:
try
{
report =rs.Render(reportPath,format,historyID,devInfo,parameters,credentials,showHideToggle,out
encoding, out mimeType, out optionalParams, out optionalWarnings, out
streamIDs);
switch(format)
{
case "PDF":
Response.ClearContent();
Response.AppendHeader("content-length", report.Length.ToString());
Response.ContentType = "application/pdf";
Response.BinaryWrite(report);
Response.Flush();
Response.Close();
break;
case "CSV":
Response.ClearContent();
Response.AppendHeader("content-length", report.Length.ToString());
Response.ContentType = "application/vnd.ms-excel";
Response.BinaryWrite(report);
Response.Flush();
Response.Close();
break;
case "EXCEL":
Response.ClearContent();
Response.AppendHeader("content-length", report.Length.ToString());
Response.ContentType = "application/vnd.ms-excel";
Response.BinaryWrite(report);
Response.Flush();
Response.Close();
break;
default:
Label1.Text = System.Text.Encoding.Default.GetString(report);
break;
}
}
catch (SoapException se)
{
Console.WriteLine(se.Detail.OuterXml);
}
"r388042" wrote:
> Hi,
> I have created an application with VIsual Studio.NET in C#. I used a
> webservice in order to view my reports.
> I want export my report in format that I want with this application.
> How can I do? What is the solution?|||Thanks you!!!
It's run very good!!!
Do you know how we can do in order to export in XML or TIFF?

Export users to other database

Dear All,
I have created users that able to access database A, now i want those
users able to access database B in same server.
How to export users from one database to other databases in the same server?
Thanks
Robert LieRobert
What is about logins? Do you have to move them as well?
Lookup at microsoft web site for two stored procedures that move logins with
their original SID.
"How to Move Logins in SQL Server"
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:uM6CTLWdFHA.892@.tk2msftngp13.phx.gbl...
> Dear All,
> I have created users that able to access database A, now i want those
> users able to access database B in same server.
> How to export users from one database to other databases in the same
server?
> Thanks
> Robert Lie

Export users to other database

Dear All,
I have created users that able to access database A, now i want those
users able to access database B in same server.
How to export users from one database to other databases in the same server?
Thanks
Robert Lie
Robert
What is about logins? Do you have to move them as well?
Lookup at microsoft web site for two stored procedures that move logins with
their original SID.
"How to Move Logins in SQL Server"
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:uM6CTLWdFHA.892@.tk2msftngp13.phx.gbl...
> Dear All,
> I have created users that able to access database A, now i want those
> users able to access database B in same server.
> How to export users from one database to other databases in the same
server?
> Thanks
> Robert Lie

Export users to other database

Dear All,
I have created users that able to access database A, now i want those
users able to access database B in same server.
How to export users from one database to other databases in the same server?
Thanks
Robert LieRobert
What is about logins? Do you have to move them as well?
Lookup at microsoft web site for two stored procedures that move logins with
their original SID.
"How to Move Logins in SQL Server"
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:uM6CTLWdFHA.892@.tk2msftngp13.phx.gbl...
> Dear All,
> I have created users that able to access database A, now i want those
> users able to access database B in same server.
> How to export users from one database to other databases in the same
server?
> Thanks
> Robert Lie

Export to word or rtf format

I would like to know if it is possible to export a report created with reporting
service
in Microsoft Word or RTF format.
Thank's in advance
Giorgio ParmeggianiNot out of the box. I don't know if there are 3rd party renderers or not.
You can do Excel and PDF which might fit your needs. And, of course, HTML.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Giorgio Parmeggiani" <gipasoft@.newsgroups.nospam> wrote in message
news:ddf4e4a662b78c7c7182df905e2@.msnews.microsoft.com...
> I would like to know if it is possible to export a report created with
> reporting service in Microsoft Word or RTF format.
> Thank's in advance
> Giorgio Parmeggiani
>|||Hi Giorgio,
Welcome to use MSDN Managed Newsgroup!
We do not support render Word (RTF) format in the SQL Server Reporting
Services 2000/2005. You may try third party solution in the link below
Design Reports Using Microsoft Word
http://officewriter.softartisans.com/officewriter-296.aspx
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

export to pdf / wrong orientation

Hello Everybody,

I have a Report created under "Reporting Services 2005". When I want to export to a pdf, it has the wrong orientation and the Size seems to big as well.
I would like to have a A4 Landscape pdf.

Thanks a lot for any kind of Help!

Change the dimensions of the report under the 'Report Properties' dialogue under the 'Report' menu.|||thanks, but I have already tried that|||Have you changed the dimensiosn to width: 11" and height 8.5" and set the margins to 0"?

Export to PDF

I have created report using the Matrix control. It looks fine in the
HTML format. The problem arises when I export the report to PDF. The
starting pages of the report look very good, but latter on some pages
are missing header and lines are out of order. This behavior continues
for few pages and after that everything is back to normal. However
after few pages everything starts all over again.
Does anybody have encountered similar problem and found a solution for
it?
Any help would be appreciated.
Thanks,
AlexWhat version of Reporting Services are you using?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
<avaranauskas@.starit.com> wrote in message
news:1131332394.237051.128260@.g43g2000cwa.googlegroups.com...
>I have created report using the Matrix control. It looks fine in the
> HTML format. The problem arises when I export the report to PDF. The
> starting pages of the report look very good, but latter on some pages
> are missing header and lines are out of order. This behavior continues
> for few pages and after that everything is back to normal. However
> after few pages everything starts all over again.
> Does anybody have encountered similar problem and found a solution for
> it?
> Any help would be appreciated.
> Thanks,
> Alex
>

Export to html and print

Hi all,
i've created a print button for users to obviously print their reports. When
it's clicked, the webpage automatically renders the report into a html view.
The i've written some javascript 'window.print() actually ;)' so it
automatically begins printing.
But when i look to the report after it is printed, i see that when i have eg
15 columns, only the first three are printed. (so only the first page). Do i
have to add something specifiek so that it prints the entire page ? Because
everything is well rendered, it just doesn't print good.
Thanks in advance !
Kind regards,
Koen Vermeire
koen.vermeire@.gmail.comI think what you are doing is the same thing as if the user printed from IE
using the print functionality of IE. You only get the page that is currently
visible.
My suggestion if you can wait is to do so. By the middle of this month SP2
will be released and it includes client side printing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Koen" <Koen@.discussions.microsoft.com> wrote in message
news:A2248AB1-0F1E-4C08-9DE4-13BB7D7BF489@.microsoft.com...
> Hi all,
> i've created a print button for users to obviously print their reports.
When
> it's clicked, the webpage automatically renders the report into a html
view.
> The i've written some javascript 'window.print() actually ;)' so it
> automatically begins printing.
> But when i look to the report after it is printed, i see that when i have
eg
> 15 columns, only the first three are printed. (so only the first page). Do
i
> have to add something specifiek so that it prints the entire page ?
Because
> everything is well rendered, it just doesn't print good.
> Thanks in advance !
>
> Kind regards,
> Koen Vermeire
> koen.vermeire@.gmail.com|||Well, the thing is, i am making this stuff because i'm currently finishing my
internship. So i wanted to deliver a complete solution to my company. But as
you said, SP 2 will be out soon, so i'll guess it'll be beter to wait for
that.
Thanks for the very fast response ;)
Kind regards,
Koen Vermeire
"Bruce L-C [MVP]" wrote:
> I think what you are doing is the same thing as if the user printed from IE
> using the print functionality of IE. You only get the page that is currently
> visible.
> My suggestion if you can wait is to do so. By the middle of this month SP2
> will be released and it includes client side printing.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Koen" <Koen@.discussions.microsoft.com> wrote in message
> news:A2248AB1-0F1E-4C08-9DE4-13BB7D7BF489@.microsoft.com...
> > Hi all,
> >
> > i've created a print button for users to obviously print their reports.
> When
> > it's clicked, the webpage automatically renders the report into a html
> view.
> > The i've written some javascript 'window.print() actually ;)' so it
> > automatically begins printing.
> >
> > But when i look to the report after it is printed, i see that when i have
> eg
> > 15 columns, only the first three are printed. (so only the first page). Do
> i
> > have to add something specifiek so that it prints the entire page ?
> Because
> > everything is well rendered, it just doesn't print good.
> >
> > Thanks in advance !
> >
> >
> > Kind regards,
> > Koen Vermeire
> > koen.vermeire@.gmail.com
>
>

Export to Excel Legal Landscape

I created a Landscape Report for Legal Paper. When I export the report to
Excel the report appears in Excel as Landscape for 8.5X11.
Does anyone know how I can resolve this issue?Have you tried changing the report page size to 8.5x14?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"sturmill" <sturmill@.discussions.microsoft.com> wrote in message
news:164F62F5-44A5-4A89-9132-D647DC10D538@.microsoft.com...
>I created a Landscape Report for Legal Paper. When I export the report to
> Excel the report appears in Excel as Landscape for 8.5X11.
> Does anyone know how I can resolve this issue?|||Are you refering to the page size in the print dialog box for excel or the
page size in the report server. I have changed the page size in the report
server to 8.5 x 14.
Same results. Exports landscape to excel but size 8.5X11.
"Jeff A. Stucker" wrote:
> Have you tried changing the report page size to 8.5x14?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "sturmill" <sturmill@.discussions.microsoft.com> wrote in message
> news:164F62F5-44A5-4A89-9132-D647DC10D538@.microsoft.com...
> >I created a Landscape Report for Legal Paper. When I export the report to
> > Excel the report appears in Excel as Landscape for 8.5X11.
> >
> > Does anyone know how I can resolve this issue?
>
>|||Report server. Does it export to PDF or TIFF legal size correctly? Just
curious...
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"sturmill" <sturmill@.discussions.microsoft.com> wrote in message
news:D879AC34-A597-409F-9493-BAACB0489FEE@.microsoft.com...
> Are you refering to the page size in the print dialog box for excel or the
> page size in the report server. I have changed the page size in the report
> server to 8.5 x 14.
> Same results. Exports landscape to excel but size 8.5X11.
>
> "Jeff A. Stucker" wrote:
>> Have you tried changing the report page size to 8.5x14?
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "sturmill" <sturmill@.discussions.microsoft.com> wrote in message
>> news:164F62F5-44A5-4A89-9132-D647DC10D538@.microsoft.com...
>> >I created a Landscape Report for Legal Paper. When I export the report
>> >to
>> > Excel the report appears in Excel as Landscape for 8.5X11.
>> >
>> > Does anyone know how I can resolve this issue?
>>|||If I go into print setup in PDF it works and TIFF works. I have gone into
Print Setup for excel and set to legal and it still doesn't work. Any other
thoughts?
"Jeff A. Stucker" wrote:
> Report server. Does it export to PDF or TIFF legal size correctly? Just
> curious...
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "sturmill" <sturmill@.discussions.microsoft.com> wrote in message
> news:D879AC34-A597-409F-9493-BAACB0489FEE@.microsoft.com...
> > Are you refering to the page size in the print dialog box for excel or the
> > page size in the report server. I have changed the page size in the report
> > server to 8.5 x 14.
> > Same results. Exports landscape to excel but size 8.5X11.
> >
> >
> > "Jeff A. Stucker" wrote:
> >
> >> Have you tried changing the report page size to 8.5x14?
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "sturmill" <sturmill@.discussions.microsoft.com> wrote in message
> >> news:164F62F5-44A5-4A89-9132-D647DC10D538@.microsoft.com...
> >> >I created a Landscape Report for Legal Paper. When I export the report
> >> >to
> >> > Excel the report appears in Excel as Landscape for 8.5X11.
> >> >
> >> > Does anyone know how I can resolve this issue?
> >>
> >>
> >>
>
>|||I am still having this issue. Is this something that will be fixed in the
next service pack? My CFO's and CEO's are getting fustrated having to do
multiple steps to print the exported document in Legal Landscape.
"sturmill" wrote:
> If I go into print setup in PDF it works and TIFF works. I have gone into
> Print Setup for excel and set to legal and it still doesn't work. Any other
> thoughts?
> "Jeff A. Stucker" wrote:
> > Report server. Does it export to PDF or TIFF legal size correctly? Just
> > curious...
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "sturmill" <sturmill@.discussions.microsoft.com> wrote in message
> > news:D879AC34-A597-409F-9493-BAACB0489FEE@.microsoft.com...
> > > Are you refering to the page size in the print dialog box for excel or the
> > > page size in the report server. I have changed the page size in the report
> > > server to 8.5 x 14.
> > > Same results. Exports landscape to excel but size 8.5X11.
> > >
> > >
> > > "Jeff A. Stucker" wrote:
> > >
> > >> Have you tried changing the report page size to 8.5x14?
> > >>
> > >> --
> > >> Cheers,
> > >>
> > >> '(' Jeff A. Stucker
> > >> \
> > >>
> > >> Business Intelligence
> > >> www.criadvantage.com
> > >> ---
> > >> "sturmill" <sturmill@.discussions.microsoft.com> wrote in message
> > >> news:164F62F5-44A5-4A89-9132-D647DC10D538@.microsoft.com...
> > >> >I created a Landscape Report for Legal Paper. When I export the report
> > >> >to
> > >> > Excel the report appears in Excel as Landscape for 8.5X11.
> > >> >
> > >> > Does anyone know how I can resolve this issue?
> > >>
> > >>
> > >>
> >
> >
> >