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…"
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…"
"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…"
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…"
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
"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. "
"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…"
"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,…"