Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
I have call_letter.dbf having fields with regno, name, category, mark, rank, address. The address field is memo.I have student address as Image format i.e JPEG having same regno. using below code i set image path to address field.
lcPictureFolder = ADDBS("D:\Muthu\ADDRESS")
USE test AGAIN IN 0 ORDER jacno
UPDATE call_letter SET address=addbs(m.lcPictureFolder) + LTRIM(str(address.regno)) + ".jpg"
i have placed Picture/OLE control on my report.frx for printing the image. I set control source = call_letter.address. when i run the report all the image in the path would print. In some situation i want to print selected images. so create a form and placed two text boxes and one command button . let assume i want to print the image regno from 20001 to 20025 so i written the code on click event of command button shows below
USE call_letter AGAIN IN 0
LOCAL lnfrom
LOCAL lnto
lnfrom = VAL(thisform.text1.Value)
lnto = VAL(thisform.text2.Value)
SELECT * FROM call_letter WHERE jacno between lnfrom AND lnto
report FORM "report.frx" TO PRINTER NOCONSOLE
But again it will print all the image in the path.
How to correct my code and How to print selected image?
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement