"I believe what they were at that time referring to as the Database Administration Tool is now called the Connector. There is lots of information on it. "

"You got the wrong forum. Sage Enterprise Intelligence is a completely different product. Sounds like you need to configure IIS like the installation manual indicates (it is VERY specific). "

"The safest way to do it is to export the reports out of one Sage site, and then import the reports into your new site on the new server. There is a bulk importer that can help you with the import process. If you use report trees, you'll have…"

"Did you change the sa password in SQL, or is the SQL service stopped? "

"You seem to be asking a question about Sage 300 functionality, not Sage Intelligence. This is a Sage Intelligence forum......"

"Have you run the BI workstation install after installing the 64 bit Excel?"

"google: Sage Intelligence Report Utility. You'll find something doing that. "

"You probably have both Functional and Source amounts on your report. Make sure your formulas are only using one or the other. "

"You need to put an Add in on your report in the Report Manager called ExtendFormulaetoUsedRows. There are lots of resources to walk  you through the process of putting the formula in your template and using the Addin to copy that formula to the…"

"Not sure about this, but the RATE field in that table is a numeric field. Why are you trying to do an RTRIM on a numeric field? That might be the problem. "

"You'd have to play around with it. It is a very complex Select statement with multiple levels. Also, if/when you do get the field added to it, I can't say what that would do to the results of the query (you might break something in adding…"

"The Select statement in the query limits the fields that can be added as expressions. I expect that if you add the field you want to the Select statement, you will then be able to add an expression using that field to your container.  Hope…"

"The first thing I would do is re-install the BI workstation and see if that fixes the problem. Failing that, you might want to run a repair on Excel. "

"There is a report that you can get through the Report Utility called General Ledger Transaction Details Including Opening Balances that can give you this information."

"You would have to replicate the data sheets (and there are numerous data sheets) to match those that you would get from a Sage 300 database. Same sheet names, same column names, same named ranges, maybe a few other things. You would basically have…"

"When you first save your template for your file, you are given a choice - "There are Pivot Tables in this workbook that use the 'Save Data with Table Layout' option. This can make your reports very large and is not recommended. Do you…"