Groups > comp.databases.ms-sqlserver > #1965

Re: .xml (XML Spreadsheet 2003) to .pdf file

Newsgroups	comp.databases.ms-sqlserver
Date	2016-06-29 00:02 -0700
References	<0a3baec3-35a4-4752-b011-16db9f97a3a6@googlegroups.com> <XnsA635D8403F24AYazorman@127.0.0.1>
Message-ID	<c6797a9f-c415-4293-ab61-508218278c01@googlegroups.com> (permalink)
Subject	Re: .xml (XML Spreadsheet 2003) to .pdf file
From	Rahul Verma <rahul.girdharwal@gmail.com>

Show all headers | View raw

On Wednesday, June 29, 2016 at 12:45:30 AM UTC+5:30, Erland Sommarskog wrote:
> Rahul Verma (rahul.girdharwal@gmail.com) writes:
> > Anybody have any idea, how to convert a .xml file (XML Spreadsheet 2003)
> > to a .pdf file in Sql Server only. 
> > 
> 
> What? SQL Server is a tool for data processing, not file conversion.
> 
> > I am trying below approach.
> > Open the .xml file in excel.application using sp_oa Methods.
> > And then save as .pdf file.
> > 
> > the issue is, I am not able to open the .xml file into 
> > window.application using oa methods. 
>  
> Calling anything that interact with the desktop from a service (which 
> does not have a desktop) is an utterly bad idea.
> 
> I would suggest that you go back to the drawing board and think of a
> different solution that does not involve SQL Server.
> 
> -- 
> Erland Sommarskog, Stockholm, esquel@sommarskog.se

Hi Erland,

Thanks for mailing.
But my requirement is to convert it within sql server.
The reason is.....I want to call this stored procedure from my stored procedure to within SSRS report to export the report in excel/ pdf.

Till yet i got success to export the same into excel (.xml) format.
The reason of exporting all by coding, not using internal ssrs export functionality, is SSRS export data in worst format.

I got success to export the same into .xml file. But unfortunately not able to open this .xml file into sp_oaMethod window.application.

Any idea/ help will be greatly appreciated.  

Thanks
Rahul

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

.xml (XML Spreadsheet 2003) to .pdf file Rahul Verma <rahul.girdharwal@gmail.com> - 2016-06-28 08:07 -0700
  Re: .xml (XML Spreadsheet 2003) to .pdf file Erland Sommarskog <esquel@sommarskog.se> - 2016-06-28 21:15 +0200
    Re: .xml (XML Spreadsheet 2003) to .pdf file Rahul Verma <rahul.girdharwal@gmail.com> - 2016-06-29 00:02 -0700
      Re: .xml (XML Spreadsheet 2003) to .pdf file Erland Sommarskog <esquel@sommarskog.se> - 2016-06-29 09:47 +0200
        Re: .xml (XML Spreadsheet 2003) to .pdf file rja.carnegie@gmail.com - 2016-06-29 14:07 -0700

csiph-web