Browse By Tags

  • Report Designer exporting Data to excel query

    Hi When I export a bespoke report to 'Data to excel' the data columns are not in the correct order: IE. Column G - PaymentAnalysis.Desc2 Column H - PaymentAnalysis.Desc4 Column I - PaymentAnalysis.Desc6 Column J - PaymentAnalysis.Desc10 …
  • Report Filter Expression Based On DATE, But Limited To 12 Months

    I'm trying to find out how to add a filter expression on a report for Sage 50 Accounts, such that the report only looks at GDN_ITEM_DATE that is from the last 12 months from the CRITERIA.GDN_ITEM_DATE_TO specified when the report is run. I then need to…