Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

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

Show all headers | 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