• 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…
  • What connectors (Data Tables) are used in Report Manager?

    How do I tell what connector (data tables) are used on a given report?
  • Adding parameters to auto distributed reports

    i have a report that is emailed regularly via windows task manager. I need to add a parameter to the report to pull in just the prior period data on one of the tables. my question is can the report run automatically given parameters require user interaction…
  • Aggregate Data in Report Manager

    I have a report connected to the IM_ItemWarehouse table and need report manager to aggregate warehouse values. I have filtered down to two warehouses but I need to report items of these two warehouses in aggregate. Its creates duplicate rows in my pivot…