Solved

Group header doesn't hide duplicates in Print Preview

Posted on 2012-04-11
7
1,435 Views
Last Modified: 2012-04-12
I have a relatively simple report, that groups on "Department". The field is set to "Hide Duplicates", which it does in Report View, but NOT in Print Preview . . .

In the attached EE d.b. (and screen print 1), it DOES hide duplicates in Print Preview.

But when I copy the same report into my main system - AS IS - it does NOT hide the duplicates in Print Preview.
- is there some setting I am missing ?

screen print 2 shows Report View - with group header hidden

screen print 3 shows Print Preview - with group header NOT hidden.
field hidden as expected in EE d.b.field hidden in my d.b. in report viewfield not hidden in my d.b. in print previewCandidates-EE.accdb
0
Comment
Question by:Alaska Cowboy
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 50 total points
ID: 37833126
Lets keep this simple.

which screenshot that is "Correct"
...and which is "Incorrect"?


This is the issue with using "Report View"...

I never use it, I always use Print Preview...

As I originally stated, you may want to rethink this design,

You seem to be having way too many issue with this "Simple" Report,....
0
 
LVL 26

Assisted Solution

by:Nick67
Nick67 earned 175 total points
ID: 37833146
I don't use the Report view for anything -- since the point of a report is almost always to print stuff. (And I think it is lying to you)
Now, I also think you aren't clear what Hide Duplicates does

Hide Duplicates will hide controls with identical values within the same report section
See the very simple sample attached.
Open rptIsHidden
Hide Duplicates will hide all the duplicate values within the detail section for ValueA
Now Open rptDoesNotWork
However, when I group by ValueA, so that each ValueA is in its own group header, they all are displayed.

You can achieve the hiding of subsequent values in successive group headers -- but you have to do that through VBA code, and not Hide Duplicates
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37833175
^Correct,

And here again, you want to use "Print Preview", ...as most Format VBA code on reports will only run in Print Preview...
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 26

Accepted Solution

by:
Nick67 earned 175 total points
ID: 37833203
Here is the sample again, with a third report, showing how to use code to get the effect you want.
Open rptUsingCode and have a look

Now, I misspoke in my earlier post.
I grouped, but not by ValueA.  The effect was clear enough, though
Hide duplicates was set to Yes, but didn't have an effect

Report View has some subtle gotchas in it --like not running the code you expect it to.
Neither @boag2000, myself, nor many others have ever quite divined what purpose MS has in creating Report View and why it differed in behaviour from what we expected in Print Preview
IsVisible-v1.mdb
0
 
LVL 47

Assisted Solution

by:Dale Fye (Access MVP)
Dale Fye (Access MVP) earned 25 total points
ID: 37833258
The only reason I can think of for using report view is to allow allow buttons on the report which will respond to input, I've used this once, to allow drill-down to another report that has more detail on a particular record in the main report, but generally prefer to provide those types of options in my reports form.
0
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 37833570
aha ! I got it . . . :-)

I had two "group headings" when I only needed a detail section and then do "Hide Duplicates" on the the right fields, now it's working great :-)

Jeff,

having done Sql for a long time and a healthy amount of reporting, I'm good on what I want to do but rough on the edges with implementing this in Access 2010. But from my perspective, I'm off to a good start . . . thank to you all here.

All,
ok on not using Report View, I was just exploring all these items and not knowing what the heck I am doing, but getting straightened out here.

I even solved another problem with this, the "group header" was taking up space when hidden, by "CanGrow", and "CanShrink"
0
 
LVL 1

Author Closing Comment

by:Alaska Cowboy
ID: 37840208
I'm good to go . . . <br /><br />Nick, your sample d.b. was what helped me, simple but then I saw what I needed to do<br /><br />Jeff, you were right . . . too complex . . . in design. What I wanted to do is still logical, imo, but  I was hacking at it in Access. So I simplified this greatly, with a simple report that has a simple sub-report<br /><br />Positions <br />     subreport = candidates<br /><br />it's very simple yet elegant for the user.<br /><br />and my original question (in another post) was to print the OTHER positions the candidate is being considered for, which I might yet do.<br />- so in that case, I might end up with <br /><br />Positions <br />     subreport = candidates<br />        subreport to candidates = OTHER positions that the candidate is being considered for<br /><br />So by simplifying it I got it working great, and should be able to add the 2nd subreport without much difficulty should the need arise.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now