I am new to Crystal. I want to create a report with the following from various tables. I have the basic query and report but its not exactly how I want.
Fields in the report are :
Group Name User Name Project
One groupname has access to several projects. I am able to suppress the groupname from repeating. However, the username appears as many times as the different projects there are. Example:
FSTGRP Amber SuperProject
FSTGRP Green SuperProject
FSTGRP Amber NiceProject
FSTGRP Green NiceProject
If Amber and Green belong to FSTGRP groupname, I don't want them repeating again. This same set of people in FSTGRP have access to 30 different projects and in this case Amber and Green will appear 30 times.
All I want to show is that a certain group has access to several projects and the members of the group are Amber and Green. Is there a way or should I use SubReport ? Thanks.
IP Logged
