Forum

Dynamic Ranges - Sum Formulas not updating based on new ranges 1 Reply

Started by Justin Numainville in General. Last reply by Paul Young 2 hours ago.

Bi Error

Started by Nimesh Vara in Sage 300 ERP Intelligence Reporting 3 hours ago.

Repository Path in user.config

Started by Paul Young in General 3 hours ago.

Sage 300c (2017) - BK-EN entries question 1 Reply

Started by Maryann Moons in General. Last reply by Jim Smith 19 hours ago.

Latest Activity

Paul Young replied to Justin Numainville's discussion Dynamic Ranges - Sum Formulas not updating based on new ranges
"Have you tried formatting these ranges as tables? This would had the same effect as dynamic ranges as Excel will automatically adjust the range's size. The SUM formulae then become static, eg.; =SUM(Table1[Sales]) You can use Name…"
2 hours ago
Nimesh Vara posted a discussion

Bi Error

Hello,I am getting the following error upon running BI reports on Sage 300.[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.Please assist.See More
3 hours ago
Paul Young posted a discussion

Repository Path in user.config

Hi,Does anyone know if it's possible to add a node in the user.config file for the repository path?We are using GPO to distribute the config file and it contains nodes for the DBServer, DBCatalog, DBUser, DBPassword, but no node for the path.ThanksPaulSee More
3 hours ago
Nimesh Vara posted a status
"Hello,I am getting the following error in BI: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa' Please assist"
3 hours ago
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service