Hi,
In one of my reports I use the table "Date" (NAV- Jet essentials) I use this one to replicate the startperiode untill a optional reporting date.
This works very good, for me and my manager.
However when others use this report they are not able to retreive the information.
Not only the viewers but also others with designer rights.
We checked the system dates in all kind of ways, but this had no effect.
Is this because the table is only accessible by super-users of NAV?
Thanks!
Gr
Michel
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi Michel,
The date Table if i'm not mistaken should be Object ID 2000000007 which is a sort of virtual table.
Check that your users have the ALL permission assigned (usually has the Date table permission in it for read access. Object Type = Table Data. ID = 2000000007) or at least check that each user has Read permission for the Table Data Object Type for that ID no in their Nav permissions.
Try that and let us know
Regards
Tom -
Jet Reports Historic Posts Hi Tom,
I think I'll just make a work around. It's not possible for me to check all permissions of all users. I only use this table to retreive all days in a period. Which is problably also possible by excel.
That might work for all users.
Thanks
Michel -
Jet Reports Historic Posts Hi Michel,
Have you tried using the NP("Dates") combined with an NL replicator? Works like a charm for most period types - definitely for all days in a period.
As you're Dutch too I permit myself to use ";" as separator and "Dag" to indicate "Day" in this example ;)=NL("Rows";NP("Dates";"1-1-2013";"31-3-2013";"Dag")) -
Jet Reports Historic Posts Hey Hans,
I'm Dutch indeed. But I'll just keep it in English here :lol:
The NP function is looking very good. Much better than the table. I always forget about the NP functions, in normal use I'm not able to use them a lot.
But in this case, perfect!
Thanks
Please sign in to leave a comment.