By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,124 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

using report to extract unique values

100+
P: 140
Hi,

form name: person_wise

i ve insert a option group.
framename=date tracker
option 1= track by date
option 2=by task....( not implemented now)

preview command button is there.
when i click that, it ask for taskstartdate and enddate and displays a report accordingly like 10/11/06 to 15/11/06. exact date result. but i want unique person name and his taskstartdate and taskenddate.

i ve given the criteria in startdate field in report as between[taskstartdate]and [taskenddate] do i ve to give for person also like this or else

tell me yeah
Nov 22 '06 #1
Share this Question
Share on Google+
2 Replies


100+
P: 1,646
Hi,

form name: person_wise

i ve insert a option group.
framename=date tracker
option 1= track by date
option 2=by task....( not implemented now)

preview command button is there.
when i click that, it ask for taskstartdate and enddate and displays a report accordingly like 10/11/06 to 15/11/06. exact date result. but i want unique person name and his taskstartdate and taskenddate.

i ve given the criteria in startdate field in report as between[taskstartdate]and [taskenddate] do i ve to give for person also like this or else

tell me yeah
Hi. Take a look at the keyword DISTINCT. It might be what you have been looking for.
Nov 22 '06 #2

NeoPa
Expert Mod 15k+
P: 31,261
i ve given the criteria in startdate field in report as between[taskstartdate]and [taskenddate] do i ve to give for person also like this or else
I think you're along the right lines here.
If you want the report to show details for only one person then you do need to restrict the output to that one person.
The Filter is the best place for this.
Nov 22 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.