Welcome Guest! To enable all features please Login or Register.



Go to last post Go to first unread
#1 Posted : Monday, November 20, 2017 10:40:46 AM(UTC)

Rank: Newbie

Groups: Registered
Joined: 11/20/2017(UTC)
Posts: 1

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?
#2 Posted : Tuesday, November 21, 2017 7:00:57 AM(UTC)

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 402

Thanks: 6 times
Was thanked: 57 time(s) in 56 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.
thanks 1 user thanked epf for this useful post.
sanyami on 11/21/2017(UTC)
Users browsing this topic
Guest (2)
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.

Powered by YAF 2.0.0 | YAF © 2003-2017, Yet Another Forum.NET
This page was generated in 0.049 seconds.