Paul
  • Seattle, WA
  • United States
Share

Paul's Groups

Paul's Discussions

Connector Module - SQL Join with two copies of a table
10 Replies

When I design a query in SQL I can add the same table twice and when I do SQL aliases the second copy of the table.When I attempt to replicate that query in Sage Intelligence it chokes and spits out…Continue

Started this discussion. Last reply by Nigel Naicker Oct 10.

sage intelligence this workbook does not have valid data to use in the report designer add-in
2 Replies

I am suddenly receiving this only on my custom report.If I run one of the other report designs the error does not appear in that report.The report used to work then something changed but I don't see…Continue

Tags: add-in, designer, report

Started this discussion. Last reply by Paul Jul 9.

Financial Report for a Specific Fiscal Period
2 Replies

Am I missing something?None of the financial report templates I can see have the ability to select or set the fiscal period for which the financial report is generated. All of the templates I have…Continue

Started this discussion. Last reply by Paul Dec 5, 2017.

 

Paul's Page

Latest Activity

Paul replied to Noble Chiko's discussion Sage 300 Intelligence Report Number Multiply by 2
"Hi Noble, If your system is multi currency check that you are not pulling in both the Functional (F) values and the Equivalent (E) values with your formulas."
15 hours ago
Paul replied to Meg McDonald's discussion Excel Question for a Combined report
"This is essentially what I am attempting to do. I thought I would be smart and use data queries inside Excel to achieve this. In Excel it works beautifully but when I save the template to Sage Intelligence then run it again all the data query…"
Sunday
Nigel Naicker replied to Paul's discussion Connector Module - SQL Join with two copies of a table
"awesome, great news."
Oct 10
Paul replied to Paul's discussion Connector Module - SQL Join with two copies of a table
"Thank you Nigel I imported the file you attached but that also failed. I have however figured out the issue. What I have found is that Sage Intelligence does not like the field aliased in the query. It is much happier when the field is aliased in…"
Oct 9
Nigel Naicker replied to Paul's discussion Connector Module - SQL Join with two copies of a table
"file attached"
Oct 9
Nigel Naicker replied to Paul's discussion Connector Module - SQL Join with two copies of a table
"Give this a try, i see you had some of your expressions aliased in your container sql query, but in the expressions on the container itself u were using the original name and not the aliased name. Also the name of the expression is what gets used in…"
Oct 9
Paul replied to Paul's discussion Connector Module - SQL Join with two copies of a table
"After all of that, I receive exactly the same error I have attached the report file for your reference"
Oct 9
Paul replied to Paul's discussion Connector Module - SQL Join with two copies of a table
"Thank you Nigel, When I copy the container it adds every field from every table even though the query only contains specific fields. I believe this is where the real issue lies. Now, there is no easy way to delete the expressions. I need to right…"
Oct 9
Nigel Naicker replied to Paul's discussion Connector Module - SQL Join with two copies of a table
"hmmm, I think that error basically means there is a mismatch between the columns in your report manager report and the source container.  I would try copying the source container, deleting all the expressions, re-adding them, then add them to a…"
Oct 9
Paul replied to Paul's discussion Connector Module - SQL Join with two copies of a table
"Hi Nigel, Just to check, I closed the report manager the opened it again and ran the report.  The error that is produced states (in summary): "The specified display field(s) ... do not exist in the data container""
Oct 9
Paul replied to Paul's discussion Connector Module - SQL Join with two copies of a table
"Thank you for your assistance Nigel. I switched to SQL Debug Mode. When the SQL Debugger appears I select 'Test SQL' and receive 'SQL Executed OK' When I select 'Continue' I receive this error: "Item cannot be…"
Oct 9
Nigel Naicker replied to Paul's discussion Connector Module - SQL Join with two copies of a table
"Hi Paul, Sage Intelligence is using the standard ODBC SQL driver in its connector module, so the syntax you use should be the same.  If the SQL code u added above is what u have in your container join, and it samples fine then that indicates…"
Oct 8
Paul posted a discussion

Connector Module - SQL Join with two copies of a table

When I design a query in SQL I can add the same table twice and when I do SQL aliases the second copy of the table.When I attempt to replicate that query in Sage Intelligence it chokes and spits out unbound exception errors.Can someone help me understand the syntax needed to achieve this in Sage Intelligence?Thank you!I can preview and sample the following but can't Check/Test the expressions without receiving errors:dbo.ICITEM AS ICITEM INNER JOIN dbo.ICBOMH AS ICBOMH ON ICITEM.ITEMNO =…See More
Oct 7
Paul replied to Cherie Biersack's discussion Customer Sales by Ship to State in the group Sage Intelligence Reporting
"Hi Cherie, I don't know which software you are using so can't comment in detail and don't know whether there is something similar already available. However, it likely that you will need to design a custom query to make that data…"
Aug 16
Paul replied to Lincoln Mahlangu's discussion Report Designer Row sets not pulling all accounts in the group Sage Intelligence Reporting
"Hi Lincoln, Without the ability to see everything it's going to be difficult to assist any further. I would edit the formula in the formula editor and check each component until you see it return a number. I believe there's…"
Jul 27
Paul replied to Lincoln Mahlangu's discussion Report Designer Row sets not pulling all accounts in the group Sage Intelligence Reporting
"Hi Lincoln, The best I can do from here is suggest you compare the account(s) that do produce a value to the account that does not. I think there is something different about the account the is not retrieved."
Jul 27

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage 300 ERP Intelligence Reporting (Formerly Accpac)

Comment Wall (1 comment)

You need to be a member of The Sage Intelligence Community to add comments!

Join The Sage Intelligence Community

At 10:02am on November 10, 2017, PRECIOUS ROMEO said…




Good Day,

How is everything with you, I picked interest on you after going through your short profile and deemed it necessary to write you immediately. I have something very vital to disclose to you, but I found it difficult to express myself here, since it's a public site.Could you please get back to me on:( preciousromeo6@gmail.com
 ) for the full details.

Have a nice day

Thanks God bless

Mrs Precious.
 

 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service