Browse By Tags

  • 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…

  • Fetching Alternate Item in query

    Trying to return the corresponding itemno for a given icitem.altset #. Normally, I'd just write a SQL statement such as: select [icitem].[itemno] from [icitem] where [icitem].[altset] but, alset is an integer, and I can't find a column in icitem…

  • What connectors (Data Tables) are used in Report Manager?

    How do I tell what connector (data tables) are used on a given report?

  • How Can I Export and Import a Container

    I am developing a new Sage Intelligence Report for a client and I had to create a new container. I know how to export and import the report. How do I transfer the required container? TIA

  • Sage 300 Intelligence Reporting module :- Run-time error '13':Type Mismatch

    We are working on a project where we have installed Sage 300 Intelligence Reporting module. The session date is showing correct format of regional date setting (e.g. South Korea). Also, all transaction screens show correct date format (e.g. YYYY-MM-DD…

  • BI Reporting Manager Error

    Hi, i get this error when open BI Report Manager I'm on Sage 2014 PU3 "The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : - SELECT…

*Community Hub is the new name for Sage City