Mel Orecklin
  • Male
  • Burwash Landing, Yukon
  • Canada
Share

Mel Orecklin's Groups

 

Mel Orecklin's Page

Latest Activity

Mel Orecklin replied to Mel Orecklin's discussion How to speed up calculation of a report in the group Sage 50 - Canadian Edition Intelligence Reporting
"I am only using the Report Designer the Report Designer to bring data into Exce.  There is no custome written code. . "
Nov 4, 2014
Ruth Gray replied to Mel Orecklin's discussion How to speed up calculation of a report in the group Sage 50 - Canadian Edition Intelligence Reporting
"Hi Mel Have you checked your SQL that you using to pull the data through from the Sage 50 database? Are you using a SQL Query, SQL Join or Graphical join to get the data from Sage 50? Is it only your custom report that is running slowly? Can you…"
Nov 4, 2014
Mel Orecklin replied to Mel Orecklin's discussion How to speed up calculation of a report in the group Sage 50 - Canadian Edition Intelligence Reporting
"Hi Ruth   In your webinar Layout Generator vs the Task Pane, you invite users to contact you.   I am running Sage 50 2015 Canadian with Excel 2010.  Learning to use Sage Report Intelligence has been one of the more frustrating…"
Nov 4, 2014
Mel Orecklin replied to Mel Orecklin's discussion How to speed up calculation of a report in the group Sage 50 - Canadian Edition Intelligence Reporting
"It was a custom report without any SQL statements and the only calculation is the annual budget which is the sum of the four quarterly budgets."
Nov 4, 2014
Ruth Gray replied to Mel Orecklin's discussion Problems getting SIR working properly in the group Sage 50 - Canadian Edition Intelligence Reporting
"Great"
Nov 4, 2014
Ruth Gray replied to Mel Orecklin's discussion Problems getting SIR working properly in the group Sage 50 - Canadian Edition Intelligence Reporting
"The BI Tools report will only show on the Financial Report Designer Report. As this is the only report that uses BI Tools Functionality in Sage 50 CDN Intelligence Reporting. So on the Sales, Purchases, Vendors and Dashboard reports etc. it will…"
Nov 4, 2014
Ruth Gray replied to Mel Orecklin's discussion How to speed up calculation of a report in the group Sage 50 - Canadian Edition Intelligence Reporting
"Hi Mel You will get a quicker response to questions if you post them in the Sage 50 CDN forum. The forum is where questions are answered, the discussion forum on this page has no alerts. And we are unable to answer directly…"
Nov 4, 2014
David Bryant replied to Mel Orecklin's discussion How to speed up calculation of a report in the group Sage 50 - Canadian Edition Intelligence Reporting
"Hello Mel, - Was this a report you designed yourself? - Did you use your own custom SQL statements and Expressions for the tables?"
Nov 3, 2014
Mel Orecklin replied to Mel Orecklin's discussion How to speed up calculation of a report in the group Sage 50 - Canadian Edition Intelligence Reporting
"Forgot to attach the screenshot"
Nov 3, 2014
Mel Orecklin added a discussion to the group Sage 50 - Canadian Edition Intelligence Reporting
Thumbnail

How to speed up calculation of a report

I am developing a simple variance report.  Sheet 1 has about 25,000 rows and it takes half an hour to generate the report.  Can anyone suggest a way to reduce the time?Running the nearest variance report in Sage 50 is near instantaneous (< 2 sec).  There should not be this much difference in the time. I experimented with running a sample of the data, but the report failed.  A screenshot is attached.  Any ideas??See More
Nov 3, 2014
Mel Orecklin replied to Mel Orecklin's discussion Problems getting SIR working properly in the group Sage 50 - Canadian Edition Intelligence Reporting
"The message "No BI Report Loaded" will result if the report is not run through the Report Generator.  The report I was complaining about is modifieable if you start with the Report Generator. Problem solved. "
Nov 3, 2014
Mel Orecklin joined Sage Alchemex's group
Nov 1, 2014
Mel Orecklin replied to Mel Orecklin's discussion Problems getting SIR working properly in the group Sage 50 - Canadian Edition Intelligence Reporting
"Here is the screen shot.  Sage Tech Support had me test with SamData.  This is a good idea as it removes any possible problem with my data set. The BI tool bar is fine if Demonstration - Financial Reports Designer 2-7 (Demo) is run, but…"
Nov 1, 2014
David Bryant replied to Mel Orecklin's discussion Problems getting SIR working properly in the group Sage 50 - Canadian Edition Intelligence Reporting
"Hello Mel - Can I get a screenshot of this message (no Bi spreadsheet is open)?"
Oct 30, 2014
Mel Orecklin replied to Mel Orecklin's discussion Problems getting SIR working properly in the group Sage 50 - Canadian Edition Intelligence Reporting
"I followed the instructions you provided Craig and the BI tab is now enabled.  The instructions are clear and are recommended to any else with the no BI tab in Excel problem. If I run a report, it opens in Excel and the BI tab is availalbe,…"
Oct 30, 2014
Craig Juta replied to Mel Orecklin's discussion Problems getting SIR working properly in the group Sage 50 - Canadian Edition Intelligence Reporting
"Hi Mel This may help and if not, search the same kb for another solution..... http://kb.sageintelligence.com/index.php?title=BI_Tools_Tab_Missing_in_Excel Personally I would not use the Report Designer for Sage 50 CDN as it uses old technology…"
Oct 29, 2014

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage50
About Me:
Long time user of accountong programs with a particular emphasis on variance reports for departmentalized charts of account.

For some reason, all of the packages I have looked at fail miserably in providing a built-in variance report. Yet as a manager this is the single most important report I use.
How long have you been using the above solution?
New User
Where did you hear about us?
Search Engine

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