Adding Transactiontype from Journals into Detailed sales report

Try this:

LEFT JOIN Journal WITH(NOLOCK) ON Journal.CustomerID = Customer.ID

Begin Column FieldName = "Journal.TransactionType" DrillDownFieldName = "" DrillDownReportName = "" Title = "Transaction Type" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 2000 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftTop End Column

~Rizza "D> I am trying to build up a customised active report, and require the

Don,

If there is no customer for a transaction this will not work, you will want to include the TenderEntry table which can be linked using TenderEntry.TransactionNumber against the [Transaction] table, then get the type of transaction using TenderEntry.Description. Take a look at the Misc - Tender Summary.qrp report.

Rob

LEFT JOIN .. not JOIN

antonio