I would like to each customer in the database send a PDF report. How does it work?
We have closed this ticket because another page addresses its subject:
Documentation - Provide a help article on how to programmatically export a report to PDF, stream, print or attach it to email via a custom Action without showing the report previewHow to - Send e-mail with PDF report attachment to every customer in database
Answers approved by DevExpress Support
created 17 years ago
(modified 11 years ago)
Hello Jens,
My apologies for the delay in responding.
>>
The report must in loop for all customers the current customer as parameter to report give.
<<
I've created a test sample to illustrate how this task can be accomplished. Please look at the following code snipped:
C#ReportData rd = (ReportData)View.CurrentObject;
IObjectSpace objectSpaceCore = Application.CreateObjectSpace();
foreach (DomainObject1 obj in objectSpaceCore.CreateCollection<DomainObject1>()) {
string name = obj.Name;
XtraReport report = rd.LoadReport(objectSpaceCore);
report.Filtering.Filter = CriteriaOperator.Parse("Name=?", name).ToString();
report.ExportToPdf(String.Format("{0}.pdf", name));
}
My sample is attached. Please let me know if this makes sense.
Thanks,
Dennis
Hi Jens,
The problem of sending email with attachments is fully documented in MSDN. So this part is not a problem.
To obtain the list of customers is enough to create an XPCollection of User objects. For instance, the controller that will manage this might look like this one:
namespace WinSolution.Module.Win { public partial class ViewController1 : ViewController { public ViewController1() { InitializeComponent(); RegisterActions(components); TargetObjectType=typeof(ReportData); } private void SendReport_Execute(object sender, SimpleActionExecuteEventArgs e) { ReportData rd = (ReportData)View.CurrentObject; ObjectSpace objectSpaceCore = Application.CreateObjectSpace(); XafReport report = reportData.LoadXtraReport(objectSpaceCore); SendEmail( << GetRecipientsList( new XPCollection<User>(objectSpaceCore.Session) ) >>, << CreateAttachment( report.ExportToPdf(...) ) >> ); } } }Please let me know in case of any difficulty related to our products when accomplishing this task.
Thanks,
Dennis
Hi Dennis,
thanks for your fast help to me. My problem is to send each customer in loop a other report-pdf with filtered log-datas of customer.
My project main part: "BO_Customer" with one-to-many relation to "BO_Customer_Logs".
Additional exists one Report "Customer_Log" with Filter "[Customer] = ?" witch reports headerinformation of customer and all customer_logs of an DateTime Period (sample last month). Well, this report with the log infos of customer must send automatically per action to all customers (mail addy is a property in BO_Customer class).
The report must in loop for all customers the current customer as parameter to report give.
Thanks, Jens!