Rank: Newbie
Groups: Registered
Joined: 11/20/2017(UTC) Posts: 11  Thanks: 1 times
|
I created one report but I want to add restriction.
I have two table one is User and other is Department and add inner join User.DepartmentID and Department.DepartmentID.
I displayed username, first name, last name, department.
But I want to add a filter that is Department. I want to display department wise user.
By default all record display when I select department from department from dropdown(this department dropdown filled from Department table)
So How to add this types of filter?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
You should create an enumerated list for your DepartmentID element.
You can check the sample for Northwind for the element 'Product Category' which is an enumerated list on CategoryId,CategoryName.
Good luck.
|
 2 users thanked epf for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 2/23/2018(UTC) Posts: 1  Location: Hanoi Thanks: 1 times
|
Originally Posted by: epf  You should create an enumerated list for your DepartmentID element.
You can check the sample for Northwind for the element 'Product Category' which is an enumerated list on CategoryId,CategoryName.
Good luck. Thank you !
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
