Evopos Help - 2.09.068

Report Views

Report Views

Previous topic Next topic  

Report Views

Previous topic Next topic JavaScript is required for the print function  

Each report is based on a Data View. A view is the combination of one or more linked database tables.

 

The Data View Used is specified in a *SQL formula field of each report. The view is defined only once in a *VW formula field. Please do not change any *VW fields as it may stop other reports from working and will get over-written on the next update. If you require additional fields please contact Customer Services. Views are re-created when the report with the *VW field is Imported.   See Report Fields for more information.

 

It is possible to create your own reports using SAP Crystal Reports. A free version of this is included with Microsoft Visual Studio. The easiest way to create new reports is to take a copy of an existing one, re-name it, and edit it to suit. If the report contains the *VW field you will need to delete it or you will have problems if the View is updated

 

The table below lists the reports where each View is defined.

 

Views                                        Tables                                Report the view is defined in                

RptContact_Mailings_vw                        Contact_Communications        Contacts-FRMMAI-Mailshot_Label_56_25

RptContacts_VW                                Contacts+Persons                Contacts-REPORT-Address_and_Contact

RptContacts_Prospects                        Contacts+Persons+Prospects        Contacts-REPORT-Prospects_Detailed

RptComposite_General_VW                Report_Composite                Sales-REPORT-Business_Summary_General

RptAged_Debt_Base                        Payments(Due)+Contacts+PersonsSales-REPORT-Aged_Debt

RptBatchSales_vw                        Header+PymtMethods+Batches        Sales-REPORT-Sales_by_Batch

RptDebtors_By_Date_VW                        Payments+Contacts                Sales-REPORT-Debtors_by_Date

RptEstimate_VW                                Init Header+Lines(Est only)        Sales-FRMEST-Estimate_A4_Plain

RptQuotation_VW                        Init Header+Lines+Picture(Est+SO)Sales-FRMEST-Estimate_A4_With_Picts

RptSales_Order_VW                        Init Header+Lines(SO)                Sales-FRMSAL-Sales_Order_A4_Plain

RptInvoice_vw                                Header+Lines                        Sales-FRMINV-Invoice_80mm

RptTransaction_Header_VW                Header                                Sales-REPORT-Sales_by_Customer

RptTransaction_VW                        Header+Lines+Cat+Tax+Store+Op        Sales-REPORT-Transaction_Profit_by_Group_Cat_Item

RptTransaction_Units_VW                Header+Lines+Units+Cat+Sales-REPORT-Transaction_Profit_with_Unit

RptOutstanding_Invoice_VW                Payments(Due)                        Sales-REPORT-Outstanding_Invoices

RptSales_Payments_Received_VW        Payments                        Sales-REPORT-Payments_by_Tender

RptSales_Payment_Recv_Rcpt_VW        Payments(Paid)                        Sales-FRMPAY-Payment_Receipt_A4_Plain

RptStatement_vw                        Payments+Lines+Contacts (Due)        Sales-FRMSTA-Statement_A4_Detailed

RptCustomer_Order_Lines_VW        `        CustOrders+Contacts+Suppliers        Items-REPORT-Cust_Orders_by_Cust

RptPurchase_Order_Recieve_Note_vw        POLines                        Items-FRMREM-Goods_Received_Note

RptPurchase_Order_VW                        POHeader+Lines                Items-FRMPUR-Purchase_Order_A4_Plain

RptStore1_Lookup_VW                        MG+SG+Cat+Tax+Store1                Items-REPORT-Stock_by_Group_Cat_Item

RptUnits_VW                                USales+UMain+Tax+PO+Con..        Units-FRMUNI-Receipt_A4_Plain

RptUnitSales_vw                                US+UM+UT+T+P+CP+ST+TH        Units-REPORT-Sales_Summary

RptUnitSalesperson_vw                        US+UM+UT+T+CP+CS+TH+TL        Units-REPORT-Sales_Summary_Salesperson

RptUnit_model_vw                        US+UM+UT+UM+T+P+CP+ST+TH        Units-FRMUNI-Form_V55_Retail

RptJob_Details_vw                        JD+UM+JIL+T+CP+Op                Jobs-FRMJOB-Job_Card_A4

RptJob_init_lines_VW                        JD+JIL+Con                        Jobs-REPORT-Items_Booked_To_Job

RptJobs_vw                                JD+UM+JIL+Con+Tax+Op                Jobs-REPORT-Jobs_Completed

RptJobs_no_parts_VW                        JD+UM+CP+T+Op                Jobs-REPORTS-Jobs_To_Do

RptJob_logged_time_vw                        Org+JD+UM+Con+Op                Jobs-Report-Logged_Time

RptNominal_Detail_vw                        NomYr+Nom(T=User)                Accounts-REPORT-Nominal_Detail

RptNominal_List_vw                        NomYr+Nom(T=User) Budgets        Accounts-REPORT-Nominal_List

RptPurchase_Payments_Nominal_vw        PT+Nom+Con                        Purchase-REPORT-Payments_by_No

RptPurchase_Transactions_vw                PPay                                Purchase-REPORT-Transactions_by_Date

RptPurchase_Payments_VW                PPay+Con+CP                        Purchase-FRMPRE-Purchase_Remittance_A4_Plain