Search results for query: *

That makes sense. I don't want to remove rows with null applications because I want to display a "No Applications" message. Is there another way to do it?

I deleted the old sub-report and recreated. I found that the issue of repeating last lines showed when I added the following formula to the section suppression: isnull({@ConCatApp}) When the suppression formula was removed I no longer had the problem. I changed the suppression formula to...

This is what I have in my sub-report which is linked by teams to the main report: Sub report grouped on Team: //Details Section WhilePrintingRecords; StringVar ConCat; ConCat:= ConCat + Trim({Supply.supplyId}) + ", " //GF Section WhilePrintingRecords; StringVar ConCat;

Sorry I lied. I thought it worked... but sadly the last value is still repeating. like I mentioned before, i copied your formulas exactly as you had them here. Any Suggestions?

I added it exactly as you had it and copied and pasted and I was still seeing the last value twice. Since I was linking from team to the main report I didn't create a team group in the sub-report. I realized that I needed to add in the formula in the group footer instead of the report footer...

Thank you LB. Team is nested in another report, so I'm using it in a sub report that links to application. When adding the following formula the last value still appears twice. I know for certain that there should be 8 applications for one team but 9 are showing by repeating the last record...

I would like to show my data in a single field: The data looks like: Team Application A MS Word B MS Excel A MS Access C Outlook B Internet Explorer I would like it to look like: A: MS Word, MS Access B: MS Excel, Internet Explorer C: Outlook Currently I have in a...