Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.
Course Of The Month
7 days, 20 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Crystal Reports VS2008 C# convert to PDF with file name.
Posted on 2014-02-02
Hey guys,
I have a function in my point of sale where clients can charge their purchases and at the end of the month we send a statement. I would like to be able to programmatically create a pdf and attach it to an email for the customers that have email addresses.
Anyone tried something like this?
Thanks,
Jerry
I have a function in my point of sale where clients can charge their purchases and at the end of the month we send a statement. I would like to be able to programmatically create a pdf and attach it to an email for the customers that have email addresses.
Anyone tried something like this?
Thanks,
Jerry
[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
3
- +2
7 Comments
What you are trying to do is possible - "DEPENDING" on what POS program you are using. I you install something like CutePDF writer, Then you can print to a PDF anywhere that you can print to a printer.
I Have to assume that when you do up an invoice it's either a CASH or an AR Transaction
If each client that charges has an AR account then just run your statement at the end of the month and print it to the PDF creator program.
As far as programmatically creating an email and automatically sending them out. Unless we are talking dozens and dozens of clients then I would want to check each statement that goes out before emailing it. Most decent POS programs will have a method of doing this.
If you paid over $1200 per license for your POS - you can be reasonably sure that that would be something they would have built in. Otherwise they should be able to add it in as a module.
If you paid under $1,000 for your whole POS system - well you gets what you pay for.
I Have to assume that when you do up an invoice it's either a CASH or an AR Transaction
If each client that charges has an AR account then just run your statement at the end of the month and print it to the PDF creator program.
As far as programmatically creating an email and automatically sending them out. Unless we are talking dozens and dozens of clients then I would want to check each statement that goes out before emailing it. Most decent POS programs will have a method of doing this.
If you paid over $1200 per license for your POS - you can be reasonably sure that that would be something they would have built in. Otherwise they should be able to add it in as a module.
If you paid under $1,000 for your whole POS system - well you gets what you pay for.
Active today
to create the PDF from CR, check http://emoreau.com/Entries/Articles/2006/10/Crystal-Reports--Part-II.aspx (first part is at http://emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx).
To send emails: http://emoreau.com/Entries/Articles/2010/07/Sending-e-mails-with-attachments-a-different-method.aspx
To send emails: http://emoreau.com/Entries/Articles/2010/07/Sending-e-mails-with-attachments-a-different-method.aspx
Active 1 day ago
This C# code should be a good starting point for you:
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-export-pdf.htm
EE no longer allows so-called "blind links", and one of the good reasons for this new rule is that links have a nasty habit of going away, so members looking for a solution to the same problem in the future may find the answer useless if it's just a blind link. So I have attached those captured pages as a PDF file and also attached the downloaded source code in a text file. Regards, Joe
<copyrighted material removed >
<mlmcc TA>
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-export-pdf.htm
EE no longer allows so-called "blind links", and one of the good reasons for this new rule is that links have a nasty habit of going away, so members looking for a solution to the same problem in the future may find the answer useless if it's just a blind link. So I have attached those captured pages as a PDF file and also attached the downloaded source code in a text file. Regards, Joe
<copyrighted material removed >
<mlmcc TA>
Is this for software that you are selling or you are going to use it ? If you are going to use it there are tools that can do that for unbeatable price. Check for example this one: www.r-tag.com. As far as I know the viewer costs just $25 and is able to do what you want: get a list of records , run reports against each record and send emails with attached reports. Reports parameters' values and email addresses will be set from the records list. All you need to do is to provide the sql which will return the list of customers, their e-mail addresses and parameter values for the reports and to click "Run". Video showing the process is available from this link:
http://www.r-tag.com/Pages/Preview_CreateBatchJob.aspx
This is know as data driven reports - the reports will be run depending on a data returned from the database. The sample shows the process started manually by the Report viewer.There are also more advanced versions, which will allow you to schedule the execution of the task so you can run it for example every night. There are bunch of schedulers available on the market. Check Ken Hamady's website to see a comparison:
http://kenhamady.com/desktopschedulers.pdf
Not all of the schedulers in the list support Data driven reports. As far as I know the feature is supported by R-Tag Report Mgr, remiCrystal and Report Runner Batch .
http://www.r-tag.com/Pages/Preview_CreateBatchJob.aspx
This is know as data driven reports - the reports will be run depending on a data returned from the database. The sample shows the process started manually by the Report viewer.There are also more advanced versions, which will allow you to schedule the execution of the task so you can run it for example every night. There are bunch of schedulers available on the market. Check Ken Hamady's website to see a comparison:
http://kenhamady.com/desktopschedulers.pdf
Not all of the schedulers in the list support Data driven reports. As far as I know the feature is supported by R-Tag Report Mgr, remiCrystal and Report Runner Batch .
Active 1 day ago
In my previous post (http:#a39827855), Michael (@mlmcc/TA) removed the copyrighted material. Thanks to him for doing that! I did not see the copyright notice at the bottom of the page (net-informations.com (C) 2014, Founded by raps mk, All Rights Reserved). I always want to be in strict compliance with copyright law, so I really appreciate Michael correcting my error. I then sent an email to the copyright holder requesting explicit permission to post the article and source code. The holder (net-informations.com) granted permission, so I have re-attached the article and source code to this post. Regards, Joe
Csharp-Crystal-Reports-Export-to.pdf
csharp-crystal-reports-export-pd.txt
Csharp-Crystal-Reports-Export-to.pdf
csharp-crystal-reports-export-pd.txt
Featured Post
Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| How to reference a column by name when iterating through a GridView ? | 1 | 48 | |
| Run tasks synchronously in background thread | 19 | 80 | |
| Running reports to the last page automatically | 6 | 26 | |
| Timeouts during development | 3 | 28 |
This article is for Object-Oriented Programming (OOP) beginners.
An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Hello everyone,
Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8.
We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
- Shell Scripting
- Programming Languages-Other
- Scripting Languages
- Notepad
- AutoHotkey
- *Scripts, Programming
Attackers love to prey on accounts that have privileges.
Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Suggested Courses
Course of the Month7 days, 20 hours left to enroll
739 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.