showing distinct members of a group

[jwaldner]

I have data that is grouped by 'teams'. each individual is a member of a team. the grouping is fine but I would like a formula to use as a header of sorts that shows each distinct member of a given team. I do not want the names reflected in the grouping of the report. it's purely informational. Each individual record has the team member name and the team in it. Seems like there should be a way, just not sure how...

 

[lbass]

Can't follow this. You say you want the names in the header but not in the grouping of the report.Do you mean you don't want to see the details?

-LB

 

[jwaldner]

I already group by the data I need to group by,
like so. one of the elements is the name of the team
member. I cant put it in the details where the data is.

team1
data data data
data data data

team2
data data data
data data data
data data data



What I would like is:


team1 [members , , ,]
data data data
data data data

team2 [members , , ,]
data data data
data data data
data data data

I suppose its the group header, but it amounts to each team member name as a string maybe separated by commas

I hope this is clearer. thanks!

 

[lbass]

I think you should insert a subreport that is linked on the team field, and then create formulas like this:

//{@accum} for the detail section:
whileprintingrecords;
stringvar names;
if instr(names,{table.name})=0 then
names := names + {table.name}+", ";

//{@display} for the report footer}:
whileprintingrecords;
stringvar names;
if len(names)>2 then
left(names,len(names)-2)

Then suppress all subreport sections but the report footer and resize to minimize footer height.

-LB

 

[jwaldner]

cool, thank you!

 

[jwaldner]

LB this worked like a champ! you rock

 

[jwaldner]

one more question:

I can add the report, but how do I get it to link to the TeamId field?

Also, when the customer sees the report it is a pdf version so there are no drill down or links available to them. I don't know that this matters, just thought I would mention it just in case.

 

[jwaldner]

Never mind, I found Change Sub Report links in the context menu, added the field to link to and presto!