Home » U++ Library support » RichText,QTF,RTF... » Documentation / more info
Re: Documentation / more info [message #55015 is a reply to message #55014] |
Mon, 05 October 2020 02:05   |
jimlef
Messages: 90 Registered: September 2020 Location: US
|
Member |
|
|
I've managed to answer some of my own questions by going to the source... here's some sample code:
sqlTaxReport.AddColumn(INVOICENUMBER, "Inv NO.", 100);
sqlTaxReport.AddColumn(DATEPAID, "Date Paid", 200).SetConvert(DateIntConvert());
sqlTaxReport.AddColumn(CUSTOMERID, "Cust. No.", 65); // OR CUSTNAME, IF NOT ANON
sqlTaxReport.AddColumn(CUSTNAME, "Customer Name", 140).HeaderTab().Show(false);
sqlTaxReport.AddColumn(TAXABLESUB, "Taxable", 80).SetConvert(ConvDouble()).SetDisplay(StdRightDisplay()).HeaderTab().AlignRight();
sqlTaxReport.AddColumn(NONTAXABLESUB, "Non-Taxable", 80).SetConvert(ConvDouble()).SetDisplay(StdRightDisplay()).HeaderTab().AlignRight();
sqlTaxReport.AddColumn(TAX, "Sales Tax", 80).SetConvert(ConvDouble()).SetDisplay(StdRightDisplay()).HeaderTab().AlignRight();
sqlTaxReport.AddColumn(GRANDTOTAL, "Total", 80).SetConvert(ConvDouble()).SetDisplay(StdRightDisplay()).HeaderTab().AlignRight();
sqlTaxReport.AddColumn(COST, "My Parts Cost", 80).SetConvert(ConvDouble()).SetDisplay(StdRightDisplay()).HeaderTab().AlignRight(); // PARTS COST FOR THIS INVOICE
.
.
.
void TaxWindow::CreateReport()
{
if (sqlTaxReport.GetCount() > 0) {
// QtfReport(sqlTaxReport.AsQtf());
Report report;
report.Landscape().Header("TaxReport");
report.SetStdFont(SansSerifZ(12));
report << sqlTaxReport.AsQtf();
Perform(report);
}
}
Successfully sets landscape mode, and creates a header that is shown on each page ("TaxReport").
SetStdFont doesn't seem to be doing anything? Of course I'm guessing as to it's field ...
Still looking for a way to set column alignment. (Was hoping sqlArray would send that info through in QTF).
|
|
|
Goto Forum:
Current Time: Wed May 14 05:08:25 CEST 2025
Total time taken to generate the page: 0.03523 seconds
|