Hi,
I have a report which has worked in the past, but now fails to run and I can't see why.
The report should return a list of vendor ID's, where the vendors have less than 6 linked items. the Jet formula is :
=NL("Rows","SQL=SELECT VENDORID FROM IV00103 GROUP BY VENDORID HAVING %Filter1%","VENDORID","1S=COUNT(VENDORID)","<6")
This has now started to return an error : The data provider returned the following error : Invalid object name 'IV00103'
Inserting the formula : =NL("Rows","IV00103","VENDORID") does work fine.
We are using Dynamics GP 2010 and Jet 2015 Update 1.
Any help would be much appreciated.
Thanks
Wilf
Date
Votes
3 comments
-
Jet Reports Historic Posts Hello Wilf -
I was able to copy/paste your function and it worked with my installation of Jet Professional 2017 and a Dynamics GP data source.
If you can let us know the exact version number of your Jet Essentials 2015 Update 1 (Click "About" on the Jet ribbon), we can try to duplicate the issue with that version.
-HP -
Jet Reports Historic Posts Hi HP,
Thanks for looking at this for me.
Our Jet version number is 15.1.15308.0
Thanks again,
Wilf -
Jet Reports Historic Posts A bit more info …..
The SQL= function appears to work with our 'Universal Database' connections, but not with either of our 'Dynamics GP' connections (currently in the midst of upgrading from 2010 to 2015).
Could it be something to do with the connection ?
Cheers,
Wilf
Please sign in to leave a comment.