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