Frans Mentz
  • Male
  • Nelspruit
  • South Africa
Share

Frans Mentz's Groups

Frans Mentz's Discussions

Access 2007 data connection not working
1 Reply

Hi.I am unable to use a Access 2013 database as data source. If I use the 2007 obdc driver I receive a IM002 error, Cannot find the file. when I change this to .mdb it doesnt understand the file…Continue

Started this discussion. Last reply by Chloe Oct 23, 2018.

The report contains too much data
5 Replies

HiI have not seen this message before. the actual report only contains 3220 rows of data and 31 Columns. This surely cannot be too much. Running the report in debugging mode it executes with no…Continue

Started this discussion. Last reply by Frans Mentz Apr 9, 2018.

PowerPivot Issues
1 Reply

Anybody else struggling with power pivot?I get any of the following issues and have tried reinstalling excel.1. Excel crashes2. Addin Enabled but not visible3. PowerPivot not updating from the data4.…Continue

Tags: Powerpivot

Started this discussion. Last reply by Keeveshin Naidoo Jan 16, 2017.

Too few Parameters on report
3 Replies

HiI have a report setup as part of a Union report. This report has no filters or parameters. Running the report on its own gives no problems, however running the report as part of the union i get the…Continue

Tags: 2007, Access

Started this discussion. Last reply by Frans Mentz May 22, 2013.

 

Frans Mentz's Page

Latest Activity

Chloe replied to Frans Mentz's discussion Access 2007 data connection not working
"Hi Frans Try using ODBC Driver for Access ODBC.png"
Oct 23, 2018
Frans Mentz posted a discussion

Access 2007 data connection not working

Hi.I am unable to use a Access 2013 database as data source. If I use the 2007 obdc driver I receive a IM002 error, Cannot find the file. when I change this to .mdb it doesnt understand the file format?FransSee More
Oct 23, 2018
Frans Mentz replied to Frans Mentz's discussion The report contains too much data
"Hi Ralph. On the connection error I cannot be of much assistance. Try the same settings on SQL server itself if you have access to  test. But I suggest you open the template in design mode. Then attach it all over again to the report. This…"
Apr 9, 2018
Ralph replied to Frans Mentz's discussion The report contains too much data
"I need to run the SI report report (Financial Analysis Cube 3-1) in Sage 300, but it’s getting error “report contains too much data”. So I go into the template (C:\Sage 300 ERP\BXDATA\SQL\Templates), and check the…"
Apr 6, 2018
Frans Mentz replied to Frans Mentz's discussion The report contains too much data
"Hi Ralph. I am not clear on the exact problem. Do you have a connection problem to the source data or do you have a issue with regards to the report showing the too much data error? Frans"
Apr 6, 2018
Ralph replied to Frans Mentz's discussion The report contains too much data
"Hi Frans, thanks for the guide. I tried to refresh the template, but it still doesn't works. It shows the screen connect to data source. after I entered the MS SQL server username and password, it shows the 'Open Connection…"
Apr 6, 2018
Frans Mentz replied to Annelize Burger's discussion Open Purchase Order Detail - Evolution in the group Free Reports Group
"Hi  Annelize You can try this container _bvInvLinesFullinner join InvNum on iInvoiceID = invnum.AutoIndexinner join _evGLaccountsFull on accountlink = iledgeraccountidwhere DocType = 5  -- Purchase Ordersand DocState in (1,3)  --…"
Sep 19, 2017

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Pastel BIC, VIP Payroll BIM, MyMonthlyReports.com, Excel On Steroids
Where did you hear about us?
Alchemex Site

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