Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Question on Group By on Subreport

Status
Not open for further replies.
Feb 4, 2009
137
US
For instance in client table has client id 15 has 5 records
clientid code
15 fev
15 swe
15 fev
15 cou
15 cou

The subreport i would like to show the result like this when run client ID 15 with distinct value:

Fev yes
chi no
cou yes
pco no
hem no
swe yes
nwo no
oth no

Please help with this group by, i'm very appeciated. thank you very much.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top