Suppress duplicates if possible

[retygh45]

Using CR11, I have a query command that looks at the database where I store my reports, and reports on all the reports I have. The data looks like this:

name location user parameter
rpt1 server bob enter date
rpt1 server bob enter rating
rpt1 server john enter date
rpt1 server john enter rating
rpt2 server bob enter date
rpt2 server bob enter rating
rpt2 server john enter date
rpt2 server john enter rating

I have it grouped on name, then on parameter, then on user, but it still lists the users twice for each report (once on each parameter).

Is there a way to suppress the users the 2nd time, so that I can display the info for each report only once:

report server, then list the parameters once each, then list the users once?

Any help is greatly appreciated, thanks!

 

[IanWaterman]

Right click each field you want to suppress. Go to common tab and at the bottom there is a check box suppress if duplicated.

Ian

 

[lbass]

You could either insert a crosstab in the group footer for name where you add the user as the row field and maximum of user as the summary. Then suppress either the label or the summary and remove the grid. Or you could accumulate the names in a formula. Create Three formulas:

//{@reset} to be placed in the name GH:
whileprintingrecords;
stringvar x;
if not inrepeatedgroupheader then
x := "";

//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar x;
x := x + {table.user} + chr(13);

//{@display} to be placed in the group footer:
whileprintingrecords;
stringvar x;

You must format {@display} to "can grow".

-LB