solution1368
asked on
pdf on the fly
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
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
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
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
ASKER
anymore solutions? That xml one seems hard to me ....:-(
Did you try the solution I suggested?
The entire code is available
mlmcc
The entire code is available
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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