web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

dashboard by user

(0) ShareShare
ReportReport
Posted on by 1,392

Hello experts,

i have this table Cue TS:

JobCueTable.JPG

For TS_OUvert ..TS_Soumis are flowField based on timesheet line table i count the number of open.. submitted timesheets.

for connectedUser  is a flowFilter to get connected (USERID) i have this code  SETRANGE(ConnectedUser,USERID); onOpen trigger on TS_Sonsl Page.      

And i have two pages(Ts_consl  and TS_PMang) that bind to the table above to show those columns as tiles on a one of the dashboards(consultant dashboard or ProjectManager ) :

Tils.JPG

my questions are :

1) Question: 

1.1 : how to show No of status of timesheets just for connected user on dashbored for consultant ( Ex : No of opened timesheet for that consultant ) ?

1.2 : how to shw status of timeshhets for JobManger for all his consultant only his consultant ( ex : no of opened timesheet for approver ID )

NB :approver ID  is the Approver ID column on timesheet line

 

2) Question :

2.1 : When i click on first tile i should only see the opened timesheet the DrillDownPageID for TS ouvert Cp IS: Time Sheet List .. WHEN I CLICK HOW TO FITLER ONLY ON OPEN STATUS FOR CONNECTED USER

By the way  i already refered to this case

Table - 9054 (used for Cue in Finance Role Centre)

Page - 9036 (Created From the Table)

Sorry for my english

Best regards

*This post is locked for comments

I have the same question (0)
  • MedInfoTech Profile Picture
    1,392 on at

    up

  • Verified answer
    CDsilva Profile Picture
    4,188 on at

    Hi Medo

    You can follow my blog article

    www.cloudfronts.com/creation-new-role-center-assigning-user-profile-microsoft-dynamics-nav-2017

    This was to create a HR role center, you can follow the steps for your Time sheet role center

  • CDsilva Profile Picture
    4,188 on at

    Hi Medo

    Kindly click on verify if my answers resolved your issue

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans