影响水晶报告中的特定记录
问题描述:
我有一个函数,当它被激活时,通过它附加的水晶报表进行迭代,将其复制到pdf,然后将其整个邮寄给客户端,每个标识字段。影响水晶报告中的特定记录
他们希望收到一份由ID分组的记录pdf,用于报告中的每个ID,省略一些特定的ID。我不知道如何将报告分解成更小的报告,或者如果可能的话,甚至从哪里开始。
答
我正在为每个用户创建每个Pdf并保存到我的Google Driver,并使用SendGrip Api发送电子邮件。
-
我用里面page.Aspx这个代码 - > aspx.cs文件。
//0. Here i am getting list users as an Object: OpsManagementController OM = new OpsManagementController(); //1. Getting Users List: var result = OM.UsersGetforInvoice(); //2. Creating folder for Invoices: string folderName = @"D:\Google Drive\MonthlyInvoices"; string fileName = ("Invoices_" + DateTime.Now.ToString("yyyy-MM-dd").ToString()); string pathString = System.IO.Path.Combine(folderName, fileName); System.IO.Directory.CreateDirectory(pathString); string folderNameEmail = @"D:\Google Drive\MonthlyInvoices\Email"; string fileNameEmail = ("Invoices_" + DateTime.Now.ToString("yyyy-MM-dd").ToString()); string pathStringEmail = System.IO.Path.Combine(folderNameEmail, fileNameEmail); System.IO.Directory.CreateDirectory(pathStringEmail); //3. Generating invoices by user name: for (int i = 0; i < result.UserDetail.Count; i++) { var userId = result.UserDetail[i].UserID; var userEmail = result.UserDetail[i].Email; var userName = result.UserDetail[i].FullName; userName = userName.Replace(@"C\O", "CO"); userName = userName.Replace(@"C/O", "CO"); // Directories for reports: var invoicePath = "D:/Google Drive/MonthlyInvoices/" + fileName + "/" + userId + " " + userName + ".pdf"; var invoicePath_email = "D:/Google Drive/MonthlyInvoices/Email/" + fileNameEmail + "/" + userId + " " + userName + ".pdf"; report2.SetParameterValue("UserID", result.UserDetail[i].UserID); report2.ExportToDisk(ExportFormatType.PortableDocFormat, invoicePath); // using sendgrip Api : EmailUtils.SendEmail_Att( new string[] { userEmail }, //TO : userEmail new string[] { "[email protected]" }, // invoiceSubject, invoiceBody, invoicePath_email ); }