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

Distinct records in report

P: n/a
Hi all,

I'm new to Reports, so please bear with me.

I have a query that produces a list of participants by project. It
also produces a list of files by project (participants and files are
both many-to-many joins with project):

_Project_ _Participants_ _Files_
Project1 participant1 file1
Project1 participant1 file2
Project1 participant1 file3
Project1 participant2 file1
Project1 participant2 file2
Project1 participant2 file3

What I want in the report that's based on this query is something like
this (my reports so far are exactly this pretty):

_Project_
Project1

_Participants_
participant1
participant2

_Files_
file1
file2
file3

Basically, I need something like a DISTINCT for participants and files,
I only want one of each unique value for each project.

Thanks for any help in advance (especially if it doesn't involve VB :)

Cheers,

Dave.

Mar 2 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In the report create 2 groupings: one for Projects, the other for
Participants. Each should have a Header section. Place the data
control for Projects in the Projects Header section and the data control
for the Participants in the Participants section.

In the Details section place the Files data control.

Done.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRAdfy4echKqOuFEgEQImkgCfTCfNOasR2SR+EGDVg2Mijz OePKkAn0kl
11kdADsz9V78bs7p1XQQyhSd
=1WeB
-----END PGP SIGNATURE-----
Dave wrote:
Hi all,

I'm new to Reports, so please bear with me.

I have a query that produces a list of participants by project. It
also produces a list of files by project (participants and files are
both many-to-many joins with project):

_Project_ _Participants_ _Files_
Project1 participant1 file1
Project1 participant1 file2
Project1 participant1 file3
Project1 participant2 file1
Project1 participant2 file2
Project1 participant2 file3

What I want in the report that's based on this query is something like
this (my reports so far are exactly this pretty):

_Project_
Project1

_Participants_
participant1
participant2

_Files_
file1
file2
file3

Basically, I need something like a DISTINCT for participants and files,
I only want one of each unique value for each project.

Thanks for any help in advance (especially if it doesn't involve VB :)

Mar 2 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.