<div>
You haven't given us a lot of info, eg the data source of the report and the fields you use in the design of the report.<br />
<br />
Have you thought of making the column 1 data field visible=false?
</div>


You haven't given us a lot of info, eg the data source of the report and the fields you use in the design of the report.

Have you thought of making the column 1 data field visible=false?

<div>
Set the <u>Hide Duplicates</u> property of those fields to True.
</div>


Set the Hide Duplicates property of those fields to True.

<div>
<div class="content wysiwyg-content">
I am creating an Organization Chart using an Access Report to be exported as a PDF.<br />
<br />
The report has a Header w/Sub header. &nbsp;The header consist of the Unit chiefs Name &amp;&nbsp;Title, and Org Name.<br />
<br />
The sub Header has the Office Assistants (OA) Name.<br />
<br />
My current report is made up of Columns and my current version wants to redisplay the Unit Chief and OA information in the first column - How do I prevent this from being displayed multiple times.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/12_w51/623511/OrgSample.png" target="_blank" title="OrgSample (11 KB)"><img alt="OrgSample" class="file-block lazyload" style="max-width: 635px;" data-src="https://filedb.experts-exchange.com/incoming/2012/12_w51/623511/OrgSample.png" /></a><br />
K
</div>
</div>


OrgSample.png

I am creating an Organization Chart using an Access Report to be exported as a PDF.

The report has a Header w/Sub header.  The header consist of the Unit chiefs Name & Title, and Org Name.

The sub Header has the Office Assistants (OA) Name.

My current report is made up of Columns and my current version wants to redisplay the Unit Chief and OA information in the first column - How do I prevent this from being displayed multiple times.



K

Access Report - Prevent duplicate data being displayed (Org Chart)

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.