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

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

X-Received	by 10.129.131.6 with SMTP id t6mr9650698ywf.42.1467234471057; Wed, 29 Jun 2016 14:07:51 -0700 (PDT)
X-Received	by 10.157.40.194 with SMTP id s60mr364104ota.5.1467234471015; Wed, 29 Jun 2016 14:07:51 -0700 (PDT)
Path	csiph.com!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!news.glorb.com!jk6no6876373igb.0!news-out.google.com!d62ni6909ith.0!nntp.google.com!jk6no6876372igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Wed, 29 Jun 2016 14:07:50 -0700 (PDT)
In-Reply-To	<XnsA63663AE190B7Yazorman@127.0.0.1>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=188.31.108.108; posting-account=dELd-gkAAABehNzDMBP4sfQElk2tFztP
NNTP-Posting-Host	188.31.108.108
References	<0a3baec3-35a4-4752-b011-16db9f97a3a6@googlegroups.com> <XnsA635D8403F24AYazorman@127.0.0.1> <c6797a9f-c415-4293-ab61-508218278c01@googlegroups.com> <XnsA63663AE190B7Yazorman@127.0.0.1>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<c3ea0050-fe2c-4848-84b3-20c83f2bdc59@googlegroups.com> (permalink)
Subject	Re: .xml (XML Spreadsheet 2003) to .pdf file
From	rja.carnegie@gmail.com
Injection-Date	Wed, 29 Jun 2016 21:07:51 +0000
Content-Type	text/plain; charset=UTF-8
Xref	csiph.com comp.databases.ms-sqlserver:1967

Show key headers only | View raw

On Wednesday, 29 June 2016 08:47:56 UTC+1, Erland Sommarskog  wrote:
> 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.

I am finding it a little difficult to understand Rahul
writing in English, but I think he's saying that SSRS
produces the data but with presentation that is ugly
or is difficult to read, but he can make it look good
in an Excel XML spreadsheet (somehow; maybe it just
does look better in Excel).  

Well, there are alternatives to SSRS for generating
reports, but some of them are very expensive - 
or are expensive when you pay, and are paid,
to use them.  Or if not expensive, only simple 
reports can be produced.

I suppose that another approach, if the data is in
SQL Server to start with, is to produce HTML,
by surrounding data values with text codes for
table arrangements and so forth.  The hard way.
For reading a report, HTML is as popular as PDF.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous 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