Book

Suggestions


Enter your email address:

Delivered by FeedBurner



Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Tuesday, October 20, 2009 – Permalink –

Display Data Once

Report Trick


Sometimes, you may have data that needlessly clutters a report.

For instance, suppose your report is listing the fields strCompany, strFirstName, and strLastName.

If there are multiple names listed for each company, and the report is sorted by company name, repeating the company information is unnecessary.

You may want to set a group header based on the company name, but there's an easier way to hide the redundant data.
  1. Open the report in Design view.

  2. Select the control that displays repetitive information.

  3. Display the control's Property sheet.

  4. Set the Hide Duplicates property equal to No.

  5. Finally, Save and preview your report.


If the data in the modified control is the same as the data from the previous record, the control is hidden.



See all Topics

Labels: , ,


<Doug Klippert@ 3:35 AM

Comments: Post a Comment