Exporting report (with graph subreport) to PDF

Hi All,
This is my first reporting services post (as I am pretty new to
working with this new technology), so if I am unclear on anything or
ignorant on anything please forgive me!
Current Situation:
--
I am exporting a report to PDF (in a Windows service). The parent
report is exporting correctly, but a subreport is erroring out. This
subreport is simply a graph at the bottom of the report, so it is
pretty crucial to the report that it is shown. The method I am using
to export this report is LocalReport.Render.
Things to keep in mind:
--
I am developing this service in VS 2005 in c#.
Is this even possible?Have you applied SQL Server 2005 SP2 to your development machine?
If not try this since applying that will also update the ReportViewer
control and the rest of the client components as well.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MattW <mdw233@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Exporting report (with graph subreport) to PDF
> Date: Mon, 08 Oct 2007 12:41:31 -0000
> Organization: http://groups.google.com
> Lines: 24
> Hi All,
> This is my first reporting services post (as I am pretty new to
> working with this new technology), so if I am unclear on anything or
> ignorant on anything please forgive me!
>
> Current Situation:
> --
> I am exporting a report to PDF (in a Windows service). The parent
> report is exporting correctly, but a subreport is erroring out. This
> subreport is simply a graph at the bottom of the report, so it is
> pretty crucial to the report that it is shown. The method I am using
> to export this report is LocalReport.Render.
>
> Things to keep in mind:
> --
> I am developing this service in VS 2005 in c#.
>
> Is this even possible?
>|||On Oct 8, 9:57 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> Have you applied SQL Server 2005 SP2 to your development machine?
> If not try this since applying that will also update the ReportViewer
> control and the rest of the client components as well.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
>
> > From: MattW <mdw...@.gmail.com>
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Exporting report (with graph subreport) to PDF
> > Date: Mon, 08 Oct 2007 12:41:31 -0000
> > Organization:http://groups.google.com
> > Lines: 24
> > Hi All,
> > This is my first reporting services post (as I am pretty new to
> > working with this new technology), so if I am unclear on anything or
> > ignorant on anything please forgive me!
> > Current Situation:
> > --
> > I am exporting a report to PDF (in a Windows service). The parent
> > report is exporting correctly, but a subreport is erroring out. This
> > subreport is simply a graph at the bottom of the report, so it is
> > pretty crucial to the report that it is shown. The method I am using
> > to export this report is LocalReport.Render.
> > Things to keep in mind:
> > --
> > I am developing this service in VS 2005 in c#.
> > Is this even possible... Hide quoted text -
> - Show quoted text -
Thanks Chris ... That did the trick!|||Not a problem :)
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MattW <mdw233@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: Exporting report (with graph subreport) to PDF
> Date: Tue, 09 Oct 2007 13:38:21 -0000
> On Oct 8, 9:57 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > Have you applied SQL Server 2005 SP2 to your development machine?
> >
> > If not try this since applying that will also update the ReportViewer
> > control and the rest of the client components as well.
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> >
> >
> >
> > > From: MattW <mdw...@.gmail.com>
> > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > Subject: Exporting report (with graph subreport) to PDF
> > > Date: Mon, 08 Oct 2007 12:41:31 -0000
> > > Organization:http://groups.google.com
> > > Lines: 24
> >
> > > Hi All,
> >
> > > This is my first reporting services post (as I am pretty new to
> > > working with this new technology), so if I am unclear on anything or
> > > ignorant on anything please forgive me!
> >
> > > Current Situation:
> > > --
> > > I am exporting a report to PDF (in a Windows service). The parent
> > > report is exporting correctly, but a subreport is erroring out. This
> > > subreport is simply a graph at the bottom of the report, so it is
> > > pretty crucial to the report that it is shown. The method I am using
> > > to export this report is LocalReport.Render.
> >
> > > Things to keep in mind:
> > > --
> > > I am developing this service in VS 2005 in c#.
> >
> > > Is this even possible... Hide quoted text -
> >
> > - Show quoted text -
> Thanks Chris ... That did the trick!
>

Export Web Archive (MHTML) not working after SP1 installed

Exporting to Web Archive (MHTML) is not working anymore after I installed
SP1. When I export to Web Archive and open the file directly IE just hangs.
When I save the file to my disk and open it from there it works. All other
formats for export work fine.
Here is a line from the report file.
w3wp!chunks!fb0!09/02/2004-11:43:28:: i INFO: ###
GetReportChunk('RenderingInfo_MHTML', 2), chunk was not found!
this=88b2b869-7080-4a6f-8c92-54eed686a400
Any tips would be appreciated. Thank you.Is this on all reports or just a specific report? Does it happen on all
client machines?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Fabian" <fhanggi@.hotmail.com> wrote in message
news:ejTeS4RkEHA.2664@.TK2MSFTNGP11.phx.gbl...
> Exporting to Web Archive (MHTML) is not working anymore after I installed
> SP1. When I export to Web Archive and open the file directly IE just
> hangs.
> When I save the file to my disk and open it from there it works. All other
> formats for export work fine.
> Here is a line from the report file.
> w3wp!chunks!fb0!09/02/2004-11:43:28:: i INFO: ###
> GetReportChunk('RenderingInfo_MHTML', 2), chunk was not found!
> this=88b2b869-7080-4a6f-8c92-54eed686a400
> Any tips would be appreciated. Thank you.
>|||Hi Brian. It happens for all reports on all client machines.
Thank you for looking at this.
Fabian
"Brian Welcker [MSFT]" wrote:
> Is this on all reports or just a specific report? Does it happen on all
> client machines?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Fabian" <fhanggi@.hotmail.com> wrote in message
> news:ejTeS4RkEHA.2664@.TK2MSFTNGP11.phx.gbl...
> > Exporting to Web Archive (MHTML) is not working anymore after I installed
> > SP1. When I export to Web Archive and open the file directly IE just
> > hangs.
> > When I save the file to my disk and open it from there it works. All other
> > formats for export work fine.
> >
> > Here is a line from the report file.
> >
> > w3wp!chunks!fb0!09/02/2004-11:43:28:: i INFO: ###
> > GetReportChunk('RenderingInfo_MHTML', 2), chunk was not found!
> > this=88b2b869-7080-4a6f-8c92-54eed686a400
> >
> > Any tips would be appreciated. Thank you.
> >
> >
>
>

Export to PDF stopped working after XP SP2 is installed on client's machine

Hi All
We are having a problem after XP SP2 is installed on the user's machine, the
export to PDF no longer works as instead on opening the report in PDF format
inside the browser it actually tries to save the .aspx page, I think it is
something to do with MIME types.
Has anyone noticed this issue and is there a work around.
Please help
Rahulmake sure your adobe reader is installed properly. we had this problem
to, and it turned out that adobe installation had not been completed.
This was only a problem with the new adobe 6.2, 6.0 was fine.
"Rahul Agarwal" <agarwal_rahul@.hotmail.com> wrote in message news:<#R7F9aOpEHA.324@.TK2MSFTNGP11.phx.gbl>...
> Hi All
> We are having a problem after XP SP2 is installed on the user's machine, the
> export to PDF no longer works as instead on opening the report in PDF format
> inside the browser it actually tries to save the .aspx page, I think it is
> something to do with MIME types.
> Has anyone noticed this issue and is there a work around.
> Please help
> Rahul

Export to Excel

I used bcp to export data to Excel file
master..xp_cmdshell 'bcp "select * from MyDB..Test" queryout
"D:\ex.xls" -c'
It is working. But It is actually stored as Text(Tab Delimitated) type.
I have to open it and do saveas and select "Microsoft Excel Workbook"
to actually save it as Excel file. Is there any way to avoid this?
MadhivananIf you actually want an Excel workbook as output, use a DTS package instead.
bcp is used only for text (or native) output.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Madhivanan" <madhivanan2001@.gmail.com> wrote in message
news:1115982106.363043.37730@.o13g2000cwo.googlegroups.com...
I used bcp to export data to Excel file
master..xp_cmdshell 'bcp "select * from MyDB..Test" queryout
"D:\ex.xls" -c'
It is working. But It is actually stored as Text(Tab Delimitated) type.
I have to open it and do saveas and select "Microsoft Excel Workbook"
to actually save it as Excel file. Is there any way to avoid this?
Madhivanan|||Can you tell me how to use DTS? I connected SQL Server as Source and
Excel ODBC as Destination. When I run I get the error 1 task(s) falied
during execution
Madhivanan|||The books online (BOL) discuss DTS. You can also post the question in the
.dts newsgroup. Also, have you tried just using the wizard? This sounds
like a straightforward export.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Madhivanan" <madhivanan2001@.gmail.com> wrote in message
news:1115983608.621366.69350@.g14g2000cwa.googlegroups.com...
Can you tell me how to use DTS? I connected SQL Server as Source and
Excel ODBC as Destination. When I run I get the error 1 task(s) falied
during execution
Madhivanan

Export to CSV/Excel

How can I export data from a table to a CSV file? I am working with an
Account package with multiple companies. Each company has its own database
and all the tables are named the same thing. I want to export all the data i
n
a table called Account for each company to a CSV file. There are about 20
companies and I do not want to manually do this using DTS. Is there a way I
could write a script to do this?
Thanks
EmmaIf you do not want to use DTS, you can use BCP. It is a command line
directive that allows you to export to a file directly from a table, view or
a query.
Rather than me explaining more about it, you can check look the BCP usage in
SQL Server Books Online.
Let me know if it helps.
"Emma" wrote:

> How can I export data from a table to a CSV file? I am working with an
> Account package with multiple companies. Each company has its own database
> and all the tables are named the same thing. I want to export all the data
in
> a table called Account for each company to a CSV file. There are about 20
> companies and I do not want to manually do this using DTS. Is there a way
I
> could write a script to do this?
> Thanks
> Emma
>|||Huge ask for a simple manual task.
one question, hope its a one time request. If so the time scripting can get
you around 100 tables to CSV using DTS.
Again in my mind i was going wild like, using osql put it in batchfile and
input account name to script it to csv. Again for such things you need to
provide accountname hardcoded.
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"Emma" wrote:

> How can I export data from a table to a CSV file? I am working with an
> Account package with multiple companies. Each company has its own database
> and all the tables are named the same thing. I want to export all the data
in
> a table called Account for each company to a CSV file. There are about 20
> companies and I do not want to manually do this using DTS. Is there a way
I
> could write a script to do this?
> Thanks
> Emma
>|||Thanks Edgardo. BCP did the job.
Emma
"Edgardo Valdez, MCSD, MCDBA" wrote:
> If you do not want to use DTS, you can use BCP. It is a command line
> directive that allows you to export to a file directly from a table, view
or
> a query.
> Rather than me explaining more about it, you can check look the BCP usage
in
> SQL Server Books Online.
> Let me know if it helps.
> "Emma" wrote:
>