Solved

pdf on the fly

Posted on 2013-06-03
5
319 Views
Last Modified: 2013-06-18
I would like to create a automatic program in c# that basically capture some data from ms sql server e.g. (select firstname from customertable where today=@today) and then
populate the data into pdf (blank pdf with some textbox) and save into like
customerId.pdf so we have 10 or 100 pdfs sitting on the particular folder like c:\pdf\

In this case, do you know any automatic or out of box software we can use? We would like to generate daily at 11:00 pm (PST) for example

thanks
0
Comment
Question by:solution1368
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39217790
Here is a method of generating it through Crystal

http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx

http://www.emoreau.com/Entries/Articles/2006/10/Crystal-Reports--Part-II.aspx

All you need to do is follow the instructions and then use the Windows scheduling capability to schedule the application

You can also build a report and use a third-party scheduling tool
http://www.kenhamady.com/bookmarks.html#desktopsched

mlmcc
0
 
LVL 23

Expert Comment

by:Michael74
ID: 39218193
If you export the query as XML you can use XSL-FO to convert to PDF

Here is some info

http://mentaljetsam.wordpress.com/2009/04/05/c-sql-server-result-in-xml/

http://www.w3schools.com/xslfo/default.asp

Michael
0
 

Author Comment

by:solution1368
ID: 39220964
anymore solutions? That xml one seems hard to me ....:-(
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39221023
Did you try the solution I suggested?

The entire code is available

mlmcc
0
 
LVL 13

Accepted Solution

by:
jonnidip earned 500 total points
ID: 39236999
I would strongly suggest you to take a look at PdfSharp and MigraDoc.
PdfSharp is a fully managed (written in c#) library that lets you integrate PDF creation from any .NET application.
I have had experience on using it and I found it much more simple and functional than SharpZipLib (from which PdfSharp derives).

Regards.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Update 21-May-2015: I temporarily removed the source code and the code snippets to make major changes to the program. Regards, Joe INTRODUCTION This Article is a follow-up to the Article entitled How To Rename-Move a Batch of PDF Files Based o…
Inserting page numbers in Portable Document Files not only enhances manageability but also makes them look professional. With numbered pages, the file appears more organized and it becomes easier to search for a particular page. The size and the vol…
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
Sometimes we receive PDF files that are in the wrong orientation. They may be sideways or even upside down. This most commonly happens with scanned or faxed documents. It is possible to rotate the view of these PDFs with the free Adobe Reader produc…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now