Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Printing From dbArchiveReader

edited September 2011 in General
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

Comments

  • edited September 2011
    Hi

    Print to file to create a PDF works OK.

    Regards

  • edited September 2011
    Hi Philip,

    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).

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.