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

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

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: .xml (XML Spreadsheet 2003) to .pdf file
Date	2016-06-29 09:47 +0200
Organization	Erland Sommarskog
Message-ID	<XnsA63663AE190B7Yazorman@127.0.0.1> (permalink)
References	<0a3baec3-35a4-4752-b011-16db9f97a3a6@googlegroups.com> <XnsA635D8403F24AYazorman@127.0.0.1> <c6797a9f-c415-4293-ab61-508218278c01@googlegroups.com>

Show all headers | View raw

Rahul Verma (rahul.girdharwal@gmail.com) writes:
> 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. 
> 

Do you mean that you first produce the .XML file and then want to produce
a PDF file from the XML? Why not produce the PDF directly from inside 
SSRS?

I don't know SSRS, so I cannot help you with that part. But I what I 
can say is that you are on the completely wrong track and you need to
return to your starting point to find a better solution to your overall
problem. It doesn't matter whether your problem to open the XML document
can be overcome, because such things should never be done anyway.

-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

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