• Creating a Parameter and Filter to Only return last 5 years out of 20 years of data in the report - This is a Consolidation Financial Report and has a Standard Report named Fiscal Year

    I Have a Consolidation Report with last 20 years financial data and I want to create a filter so that the report only returns last 5 years of data, I tried including system parameters to the standard report 'Fiscal Year' First but whenever I run that…
  • report from excel container, only runs if workbook open

    Running Sage 2017 SP1, with Excel Container I have created an excel link for a large report that I'm going to pull several small reports from for distribution. This runs perfectly if the linked excel report is open but not if it's closed. I will…