I am using a Dutch version of Jet 2013 on a Dutch NAV 2013 database.
Trying to get columns per month out of the Date table doesn't work.
The formula is =NL("Kolommen";"Datum";;"Periodesoort";"Maand";"Begindatum";$C$2;"Limiet=";"12")
Translated: =NL("Columns";"Date";;"Periode type";"Month";"Period start";$C$2;"Limit=";"12")
When I specify 'Maand' (dutch for Month) as an option for Period type the webservice returns an error message:
'Maand' is not a an option. The existing options are: Date, Week, Month, Quarter, Year
When I specify 'Month' there is also an error:
Invalid Filter 'Month'
The formula is expecting a dutch option and the webservice an english one.
I tried the option number (2) instead of the name (Maand), but that won't help. I get the same message as if I specified 'Maand'.
I also tried to use the table and field numbers instead of the names, but no luck eiter.
Seems like a bug to me.
Anyone with me on this?
rmw
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi rmw,
Please report suspected issues like this by creating a ticket with Jet Reports Support. Then someone from Jet can look at it, and if it is an issue, it can be fixed. Thanks!
Regards,
Hughes -
Jet Reports Historic Posts Hello,
Is there an solution for this problem? I have the same issue but no work around.. -
Jet Reports Historic Posts I was able to bypass this using NP("Dates"), due to a tip of mr. Hans 'JetReports' Fousert :)
You need to rewrite some more, because NP("Dates") gives you a date and not a key like NL("Columns";"Date";;) does.
But it worked.
A ticket was submitted, but no answer yet.
rmw
Please sign in to leave a comment.