Hi, I have to create a report in a pdf file. but all the data for that file is in db. I have already wirtten a procedure to fetch that data, the procedure shows the exeact data ,but i want to show all the result in a pdf file. does any one know how this can be done. Pallavi
Use Reports to show the data and export them to PDF from there Madhivanan Failing to plan is Planning to fail
hello which reports u r refering to? Is it using the SQL server Reporting services? I dont know how to do tht. could u pls tell me Pallavi
If you use any Reports (SSRS or Crystal) use Export option and export the data to pdf Otherwise refer this http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=1487 Madhivanan Failing to plan is Planning to fail
See if this helps:http://www.sqlservercentral.com/columnists/mivica/creatingapdffromastoredprocedure.asp -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Heute schon gebloggt?http://www.insidesql.de/blogs