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

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

Path	csiph.com!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: .xml (XML Spreadsheet 2003) to .pdf file
Date	Wed, 29 Jun 2016 09:47:56 +0200
Organization	Erland Sommarskog
Lines	25
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>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx02.eternal-september.org; posting-host="54b1a6a8d0d78ca3d7e24b3701f94214"; logging-data="25417"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+F3y3tgqC2FP9oeP7kUGRp"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:Rkeu2X8034vAq2iU7G3Xg+SQplU=
Xref	csiph.com comp.databases.ms-sqlserver:1966

Show key headers only | 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