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: 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> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: 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 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.