• Report Designer Reverse Criteria

    Afternoon, Can anybody tell me how to reverse the criteria for this report? It is currently showing my works orders by number starting from 1 in the drop down, whereas I would like it to be the opposite and start from largest number first. Thanks…
  • Matching Transaction Report

    Hi everyone, I'm fairly new to Sage 200 and still trying to discover it's possibilities. I've been wondering if anybody has any idea if there is any report or how to create one that will basicaly generate you a list showing all the Credits and Debits…
  • Report Designer

    Hello, I have a question about getting a net value on a nominal transaction report. I have a column for Debit and Credit but the net value is not calculated. Thank you
  • Sage Report Designer percentage increase in values?

    Hi, I have created a simple report that outputs information from purchase orders based on an item code or a supplier and it gives me when,whom and when those items where purchased, with po number quantity and unit buying price. What I would like to…
  • Sage 200 Report Designer - Join Not Detecting New Column in View

    On our picking list report we've got a join to an SQL view called 'SOPAdditionalChargeView' which is used to display the additional charge line for the order at the top of the picking list. Without going into too much detail I have added a column to this…
  • Sales Returns - How Do I Make Them Negative On A Report

    Hi I have wrote a report which gives me sales by product, country's, analysis codes etc and is pulling through our w/o cost. However I am really struggling with the logic of how I can turn sales returns into a negative number. Does anyone know…
  • Report Designer, Expressions? or Conditional Formatting? (CONT)

    Further to my earlier post about conditional formatting. I now need to change it slightly and use a different field, but also to have 3 colours instead. I will see if I can explain it. I have butchered a copy of the Purchase Orders and Returns report…
  • Report designer error message when trying to apply a filter

    The report could not be generated. No applicable method 'StartsWith' exists in type 'DynamicClass13' I'm using a modified zero value order lines report to get invoice item descriptions and their respective invoice numbers into columns. When I try…
  • Sage Report Designer - Criteria not working

    Hi, Using Sage 200c and Sage Report Designer, I am making a report to produce invoice from my custom table. I have apply criterion to print specific row based on my criterion value. However, even after applying criterion as in image, my report still…
  • Workspace Report Filters not working!

    FormerMember
    FormerMember
    Hi Guys, We have recently moved to Sage200 and working through everything - mostly gone well and getting there, but we have an issue with one of our Workspace Reports for web users - when they click on a report, the filters do not all appear, only one…
  • Report Designer - unable to add custom data provider

    I'm trying to add custom data fields to a report using Report Designer but am unable to select a different data provider as was possible in previous versions of Sage 200, I'm currently using Sage 200c The data providers available in this version is…