All Discussions Tagged 'SQL' (16)

Discussions Replies Latest Activity

pass through variable invalid sql query

Have created a very simple PTV and trying to use it in a union report.  Works fine on initial report (pulling from container with PTV). But…

Started by Eric Anderson

9 Jul 25, 2014
Reply by Peter Scully

Sage 300 SQL - Report Execution Error

Please can someone shed some light on the error received when running a Sage 300 report:

Started by Chris Millar

2 Jun 24, 2014
Reply by Shwu Hua Gan

Using SQL Statements in a Container

I have SQL statements that work fine in a SQL query, but I can't get them to work in a container. I've tried this one many different ways -…

Started by Kathi Evans

2 Jun 12, 2014
Reply by Kathi Evans

Report Designer Add-in SQL errors

With the Report Designer Add-in (Sage ERP 300 version 2012) there seems to be issues with at least 2 of the Union Sub Reports. When install…

Started by Awie van den Berg

4 Jun 4, 2013
Reply by Nigel Naicker

Help creating a SQL Join

I need to create a SQL join for IM_TransactionHistory to the AR_InvoiceHistoryHeader table. Because the AR Invoice number in the IM_Transac…

Started by Doug Walker

22 Mar 22, 2012
Reply by Nigel Naicker

Analysis (OLAP) Module and existing Microsoft SQL Analysis Cubes

The SAI Analysis module supports the creation of Microsoft local cube files or .cub files off any ODBC compliant datasource. However, SAI a…

Started by Stephen Coull

0 Mar 15, 2010


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service