Hi Guys,
Just installed Jet Express which I try to link to a Nav 2013 R2 database.
Connection succeeded but…
Using Tabelbuilder I try to combine/link two tabels (e.g. Sales Header & Sales Line) but during this action I receive a error:
System. FormatException
By System.Text.StringBuilde.AppendiFormat (FormatProvider provider, String format, object [] args)
by JettableUI.VeiwModels.ReportLinkFieldViewModel.ResetHeader()
etc.
What have I done so far?
* Excel = 64 bit
* Jet Express = 64 bit
* Reinstalled Jet Express
* Compiled again the objects in Navision
* Delete and add the Webservice
Still all without any result……help
Date
Votes
7 comments
-
Jet Reports Historic Posts Hello Alphatron,
Close Excel completely.
Go to the Windows Control Panel > Region and Language > Switch to French (France).
Test the Table Builder again.
If it works correctly then close Excel completely.
Go to the Windows Control Panel > Region and Language > Switch to English (United States) (or your native language).
Click "Additional Settings…" and "Reset".
Open Excel and test the Table Builder again.
If the error still occurs then close Excel completely.
Navigate to the Windows Control Panel > Programs and Features.
Run a repair of both Microsoft Office and Microsoft .NET Framework.
If you are not utilizing Microsoft .NET Framework 4.5.2 then I would advise upgrading to it from this link: http://www.microsoft.com/en-us/download/details.aspx?id=42642
Please let me know the results.
Best regards,
MWilson -
Jet Reports Historic Posts Dear MWilson,
Thank you for your respons.
I followed your instructions but unfortunately without any succes.
thx, Alphatron -
Jet Reports Historic Posts Hello Alphatron,
A new release of Jet Express is available at http://jetexpress.jetreports.com/regionhome.php
Can you please remove your currently installed version and upgrade to the latest release to see if you still experience this error?
If you still experience this error can you please indicate what Region and Language your Windows settings are configured for?
Can you also indicate what language Dynamics NAV and your Jet Data Source Settings are configured for?
Best regards,
MWilson -
Jet Reports Historic Posts Hello Alphatron,
I just spoke with the Jet Reports development team and it appears that the upgrade will not resolve the issue.
It has been determined that there is a issue with Dutch and German language translations in the last two releases of Jet Express.
You will either need to downgrade to Jet Express 2015 Update 1 Build 15.1.15181.0 or wait until the next release of Jet Express is available.
Best regards,
MWilson -
Jet Reports Historic Posts Dear Mister Wilson,
Ok no problem.
Do you have any idea at what date this version will be released?
I try to find version Jet Express 2015 Update 1 Build 15.1.15181.0 but unfortunately I can't find it on the web.
Do you have any link or url for me?
Thx, Alphatron -
Jet Reports Historic Posts Hello Alphatron,
I have identified a workaround for this issue until the next build of Jet Express is available.
Open the Jet Application Settings and change the "User Interface Language" to "English" (you must restart Excel).
Jet Express should work as intended until the update is available.
If this is not a sufficient workaround please let me know and I can see about obtaining an older release of Jet Express for you as Jet Reports does not offer older versions of Jet Express for download directly.
Best regards,
MWilson -
Jet Reports Historic Posts Dear Mister Wilson,
Great, this works, I am able to link two tables so I can continue.
Thank you very much for your help and patience
Greeting Alphatron
Please sign in to leave a comment.