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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)