A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Problem with repeating values in report



 
 
Thread Tools Display Modes
  #1  
Old April 18th, 2010, 03:45 AM posted to microsoft.public.access.reports
David K[_3_]
external usenet poster
 
Posts: 16
Default Problem with repeating values in report

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.
  #2  
Old April 18th, 2010, 07:54 PM posted to microsoft.public.access.reports
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default Problem with repeating values in report

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.


--
Duane Hookom
MS Access MVP


"David K" wrote in message
...
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.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:37 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.