Printing From dbArchiveReader
Hi
Strange Customer specific issue which I would appreciate advice on how to
proceed and resolve this issue.
After printing the rtm based invoice, we store the image in a blob field as
below...
InvTable.edit;
InvTable.FieldByName('INVOICE_PRINTED').AsDateTime := now;
TBlobField(InvTable.FieldByName('INVOICE_RAF')).LoadFromFile(ppViewer1.Report.ArchiveFileName);
InvTable.post;
If the customer wants as to print a copy we load DBArchiveReader and then
assign this to ppViewer as below....
DBArchiveReader.DatabaseSettings.BLOBField := 'INVOICE_RAF';
DBArchiveReader.DatabaseSettings.NameField := 'INVOICE_NO';
DBArchiveReader.DatabaseSettings.Name :=
winInvCopy.InvoiceTable.FieldByName('INVOICE_NO').value;
ppviewer1.report := DBArchiveReader;
ppViewer1.RegenerateReport;
This has worked well over the years but we have a specific customer issue
where we are then trying to print the copy.
After the Print Dialog is displayed, and printer assigned, on 'Print'
nothing appears to be sent to the printer.
We have tried with 2 different printers on the Customers site.
Any ideas why nothing is sent to the printer and how to investigate this?
Thanks in advance
Philip L Jackson
Strange Customer specific issue which I would appreciate advice on how to
proceed and resolve this issue.
After printing the rtm based invoice, we store the image in a blob field as
below...
InvTable.edit;
InvTable.FieldByName('INVOICE_PRINTED').AsDateTime := now;
TBlobField(InvTable.FieldByName('INVOICE_RAF')).LoadFromFile(ppViewer1.Report.ArchiveFileName);
InvTable.post;
If the customer wants as to print a copy we load DBArchiveReader and then
assign this to ppViewer as below....
DBArchiveReader.DatabaseSettings.BLOBField := 'INVOICE_RAF';
DBArchiveReader.DatabaseSettings.NameField := 'INVOICE_NO';
DBArchiveReader.DatabaseSettings.Name :=
winInvCopy.InvoiceTable.FieldByName('INVOICE_NO').value;
ppviewer1.report := DBArchiveReader;
ppViewer1.RegenerateReport;
This has worked well over the years but we have a specific customer issue
where we are then trying to print the copy.
After the Print Dialog is displayed, and printer assigned, on 'Print'
nothing appears to be sent to the printer.
We have tried with 2 different printers on the Customers site.
Any ideas why nothing is sent to the printer and how to investigate this?
Thanks in advance
Philip L Jackson
This discussion has been closed.
Comments
Print to file to create a PDF works OK.
Regards
This is not a known issue. Which version of ReportBuilder and Delphi
are you using?
Based on the fact that your other customers do not experience this issue
and that the customer that does has tried multiple printers without
success, this leads me to believe that it is a printer access issue.
Perhaps have them try to print from a different machine and see if that
helps. Also if they are printing to a network printer or from a
terminal server, be sure they have proper access to the printer/driver
from your app.
Another thing you might try is installing a file based printer driver
and have print directly to that instead of an actual printer device.
(Microsoft XPS Printer driver or a PDF printer driver).
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com