All Discussions Tagged 'SQL' (16)

Discussions Replies Latest Activity

SQL credential error while choosing parameters

We keep get an user error for SQL credentials whenever we click on parameters. For example choosing period will pop up an error. Error scre…

Started by selva kannan

4 Nov 22, 2018
Reply by Mel

Sage 100 SQL Syntax Help

I created a Pass Thru Variable for a date to enter at run time. I need the SQL syntax to create the 2 digit month from Pass Thru Variable…

Started by Doug Walker

15 Oct 26, 2018
Reply by Peter Scully

Variable at runtime

Is there any way to have a user input a variable at runtime, which will be inserted into an underlying SQL query?

Started by modhorat

1 Nov 7, 2017
Reply by NATE

Using DATEADD function on an Expression in a container

Hello, I am using the downloadable Container "Sales Analysis SX3 1-0 (C4-0-2)" on Sage Intelligence for X3 v7.42.2.  This is a Join contain…

Started by Erik Allen

4 May 4, 2017
Reply by Peter Scully

SQL Quick Tip - Resolve Syntax Error

Working with a report that had been previously designed.  Trying to take an expression that currently resides at the RAWDATA sheet and mov…

Started by Deborah S Judy

3 Mar 3, 2017
Reply by Deborah S Judy

SQL syntax in a SQL Query Container Type - Issue with using Left / Right function

Hi, I'm trying to create a report based on a SQL query tested in my SQL Management Studio. When I'm creating a new Container and using the…

Started by Eric Gauvreau

9 Feb 12, 2016
Reply by Peter Scully

Sage 50 US Intelligence Reporting -- Stuck on an inventory report's design

Hello all,   I'm trying to write a custom backorder report for Sage 50 Intelligence Reporting. The report needs to provide, for each item o…

Started by Nestor Diaz

7 Jan 25, 2016
Reply by Nestor Diaz

"Error in assignment" with custom SQL query

Hello, I'm writing a custom report in order to create a pick list for a Sage 50 US customer. I've defined the container for the report as…

Started by Nestor Diaz

1 Oct 12, 2015
Reply by Nestor Diaz

Sage 50 US-Need Help Setting up an Alias Table

Anyone know of any documentation for setting up Alias Tables with Sage Intelligence?    Situation: I'm working with Sage 50 US.  I need bot…

Started by Suzy Rabb

3 Aug 25, 2014
Reply by David Bryant

Sage 50 US-Need Help Setting up an Alias Table

Anyone know of any documentation for setting up Alias Tables with Sage Intelligence?    Situation: I'm working with Sage 50 US.  I need bot…

Started by Suzy Rabb

1 Aug 22, 2014
Reply by Peter Scully

RSS

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service