Problem with repeating values in report

[David K]

I have a special kind of “eliminate blank lines†question. Here’s a
simplified version of the issue.

I have a query with multiple joins which returns a key value (Name), one or
more (there will always be at least one) “children†values and then another
column pulling different children into the join. The query works fine but my
problem comes with trying to clean up the output. Consider that the
following is coming back from the query.

Name Repeat1 Repeat 2
1 R1 RA
1 R1 RB
1 R1 RC
1 R2 RA
1 R2 RB
1 R2 RC
2 R2 RD
2 R2 RE
2 R3 RD
2 R3 RE

Within the report designer, if I group on Name and set Hide Dups to Yes on
property sheet for each columns I can get this:

Name Repeat1 Repeat 2
1 R1 RA
RB
RC
R2 RA
RB
RC

2 R2 RD
RE
R3 RD
RE

But what I really would like is (the line between the groups is a nice to
have but I can live without it…can’t find a way to edit the group footer
unless I add totals)

Name Repeat1 Repeat 2
1 R1 RA
R2 RB
RC
2 R2 RD
R3 RE

I can think of some ways to do this with a lot of custom programming but I’m
wondering if there’s a way to do this directly in the reporting tool.

 

[Duane Hookom]

I would use a main report based on just the [Name] field (IMO, change this
to something that won't bite you later). Then create two subreports based on
totals queries that group by the new Name field and Repeat1 then Repeat2.