axStart: Best practice for creating/changing sales/purchase & project reports.

[Blog bot]

Источник: http://axstart.spaces.live.com/Blog/...C0A0!211.entry
==============


Introduction
The report technology in AX is not so complex. But getting the data on the right spot is something else. Most developers are not aware of some general frameworks that do the biggest deal of the job for you. Let’s start with the Setup/Form/Form Setup; this is available in the Sales, Purchase and Project Module. This Form setup tells you:
1                 What dimensions should be printed.
2                 Witch document notes are printed.
3                 If you use blank /partly or pre-printed Paper.
Also the Form Setup is there this can be used to add just one line to the report. My advice to you is to first configure these setting correct, before you start changing the report. Some general advice before start coding. And of course we also still can use the notes from document management.
1       Avoid fixed positions of the fields. Fixed size is ok, because you can still insert a new field without any conflict of changing the positions of all other fields in that report.
2       Use as match as possible the ModelFieldName property for getting everything in the same column. There is one known bug, If the ModelFieldName field has the label above and you field has the label left position, you’re left position label simply disappear. The solution is: place this label in an additional text field.
3       Use the right tables. You should be aware that the user can throw away journals, SalesOrder & Purchase orders. But your reports should still work. Bellows list shows you the right tables to use. General: Don’t use all tables that belong to the table group Worksheet Header & Worksheet Line. They can be thrown away.
 
Module
Document
-Jour, -Trans & -Link
Sales
Quotation
CustQuotation…
 
Confirmation
CustQuotationConfirm, CustConfirm…
 
Picking list
InventPickingList…
 
Packing slip
CustPackingSlip…
 
Invoice
CustInvoice…
Purchase
Requisition (Purchase order)
VendPurchOrder…
 
Receipts list
VendReceiptsList…
 
Packing slip
VendPackingSlip…
 
Invoice
VendInvoice…
Inventory
 
InventTrans
 
InventDim
If you have to add fields on the inventDim line, do that on this place. Table InventDim method dimReportStrAll. This method is used on almost all InventDim printing.
Barcode printing.
Use the Barcode class. The Barcodes are stored in Basic/Setup/Barcode Setup.
  barcodeTable   = qr.get(tablenum(tutorial_BarcodeTable));
  barcodeSetup  = BarcodeSetup::find(barcodeTable.barcodeSetupId);
  barcode            = barcodeSetup.barcode(); //used on display method
 
   if (barcodeSetup && barcodeSetup.BarcodeType != BarcodeType::NoBarcode)
   {
           
            BarCodeField.font(barcodeSetup.FontName);
            BarCodeField.fontSize(barcodeSetup.FontSize);
   }
   else
   {       //hide barcode field
            BarCodeField.visible(false);
   }
 
Paper Tray
Changing paper trays is possible in AX even in The Fetch of a report. You do this by changing the properties of the printJobSettings class. There are 3 minor issues.
1                 It only works for printers defined on the client.
2                 You Can only switch the tray once (3.0, I don’t know for 4.0)
3                 It will not work when you first print to screen and then to de printer.
pjs = reportRun.printJobSettings();
pjs = element. printJobSettings();
for (q = pjs.getNumberOfTrays(); q > 0; q--)
 {
        info(int2str(q) + " - " + int2str(pjs.getTray(q));
 }
 pjs.paperTray(pjs.getTray(q)); //Note the internal tray number can be different than the external number.
 
And trust me by the time you have created version number 7 of your invoice report. The customer is happy.

Источник: http://axstart.spaces.live.com/Blog/...C0A0!211.entry