Doug Hart
  • Male
  • Tampa, FL
  • United States
Share

Doug Hart's Groups

Doug Hart's Discussions

Incorrect syntax near ')'
1 Reply

Incorrect syntax near ')'Since this has happened more than once, it must be *me*! I started with a native SI template for Sage 500 --the "Report Designer Add-In - Fiscal Year Detail...", which has…Continue

Tags: 102, 2147217900, syntax, Incorrect

Started this discussion. Last reply by Doug Walker Jul 24, 2018.

How do I create a Consolidated Container for Sage 500
1 Reply

online help in the Connector module states that you can "Create a new container using the Consolidation connection" but I don't see any Consolidation connection?Continue

Tags: Connector, Consolidated

Started this discussion. Last reply by Doug Hart Jul 28, 2017.

"Excel has stoppped working" when copy>paste from one Designer Add-In workbook to another
6 Replies

I'm trying to consolidate multiple separate Sage Intelligence Designer Add-In templates into one. I've successfully copied two P&L based reports as new worksheets into my new "master" template…Continue

Tags: crash, excel, add-in, designer, 500

Started this discussion. Last reply by Doug Walker Sep 8, 2016.

 

Doug Hart's Page

Latest Activity

Doug Walker replied to Doug Hart's discussion Incorrect syntax near ')'
"Go into the Container and click on the FiscYearPer field. On the Properties tab click on the ellipse next to Expression Source. Click on the Execute button. Does it error out? If it does copy and past the SQL code here."
Jul 24, 2018
Doug Hart posted a discussion

Incorrect syntax near ')'

Incorrect syntax near ')'Since this has happened more than once, it must be *me*! I started with a native SI template for Sage 500 --the "Report Designer Add-In - Fiscal Year Detail...", which has the following columns/ContainerExpressions:CompanyFiscalYearFiscalPeriodPeriodStartDatePeriodEndDateI tried to add one additional field from one of the two source tables in this container, the FiscYearPer column from tglFiscalPeriod. For those unfamiliar with the data structure, presuming we're…See More
Jul 24, 2018
Doug Hart replied to Sue Moore's discussion Adding a subreport to an existing union report
"Thanks Doug, I'll try that and advise if it works."
Jun 29, 2018
Doug Hart replied to Sue Moore's discussion Adding a subreport to an existing union report
"This approach didn't work for me, any other suggestions?"
Jun 28, 2018
Doug Hart replied to Barry McCuistion's discussion Sage500 - RANGES - when the natural account is not in the first segment
"Is there any other option rather than using the wildcards? I have a client with a similar issue where the Natural account is the second of three segments. If all of their FRx formulae were just XXXX to YYYY it would be a pain, but manageable. In…"
Dec 1, 2017

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage 500 ERP Intelligence Reporting (Formerly MAS)
Website
http://rklesolutions,com
Where did you hear about us?
Sage Intelligence website

Comment Wall

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

Join The Sage Intelligence Community

  • No comments yet!
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service