Solved

pdf on the fly

Posted on 2013-06-03
5
324 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 101

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:Michael Fowler
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 101

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

Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Question has a verified solution.

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

*Adobe Acrobat 9 was used for this article.  Particular steps may vary depending on software versions. Adobe Acrobat has many, many variables that my be utilized to customize your forms for clarity and ease of use. The Form Editing Tool will be y…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
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) …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

627 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