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

Notification

Icon
Error

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

Rank: Newbie

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

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

Rank: Administration

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

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
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.050 seconds.