U++ framework
Do not panic. Ask here before giving up.

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 Go to previous messageGo to previous message
jimlef is currently offline  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).
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: how can i get the image in the RichText?
Next Topic: Report Perform() and printing
Goto Forum:
  


Current Time: Sun Apr 26 22:47:00 GMT+2 2026

Total time taken to generate the page: 0.00538 seconds