Announcement

Collapse
No announcement yet.

Chart that only shows stats based on user that is logged in?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Chart that only shows stats based on user that is logged in?

    Hello,

    I'm doing a pie chart based off a grid with a "Group-By" on the number of types of service in a "Master Work Order Table".

    Right now the group-by totals the service type for all records in the table.

    I only want to display the records that are relevant to the user logged in?

    I can access the logged in user with a global variable [usr_company] but I'm not sure how I can get the group-by to only group the records that are relevant to the logged in user?

    Any help is greatly appreciated.

  • #2
    You are going to have to add the usr_company to the master work order table your grouping on and then add in the sql statement where usr_company = '[usr_company]'

    Comment

    Working...
    X