FOR EACH PRODUCT // Create a report instance specific to this product RPT_StockCard.SetParameter("ProductID", PRODUCT.PRODUCT_ID) RPT_StockCard.SourceFilter = "PRODUCT_ID = " + PRODUCT.PRODUCT_ID // Generate one PDF per product, or merge into a single PDF using iMerge iPrintReport(RPT_StockCard, iPDF, "Card_" + PRODUCT.REFERENCE + ".pdf") END
Voici un template que vous pouvez concevoir en 10 minutes dans l’éditeur d’état WinDEV : gestion de stock windev pdf
HConnect("MaBDMySQL", "Driver=MySQL ODBC 8.0;Server=localhost;Database=stock;") Requête("SELECT * FROM produits WHERE qte < seuil", "rqAlerte") État_Alerte.Source = rqAlerte iDestinationPDF(État_Alerte, "Alertes.pdf") FOR EACH PRODUCT // Create a report instance
// 3. Generate PDF Invoice iDestination = iPDF iMerge = iNoMerge PDF_Path = "C:\Invoices\INV_" + sInvoiceNumber + ".pdf" iPrintReport(RPT_Invoice, iPDF, PDF_Path) "Driver=MySQL ODBC 8.0
WINDEV includes a built-in example project called (or similar). You can: