91 lines
5.6 KiB
HTML
91 lines
5.6 KiB
HTML
|
|
<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
|
|
<html>
|
|
<head>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
|
|
|
|
<meta name="generator" content="Adobe RoboHelp 2019">
|
|
<title>Add or Remove Report Columns</title>
|
|
<link rel="StyleSheet" href="../qbpos.css" type="text/css">
|
|
<style type="text/css">
|
|
/* FORCE ALL FONTS TO 12PT */
|
|
* { font-size: 12pt !important; }
|
|
body, p, li, ol, ul, div, span, td, th, h1, h2, h3, h4, h5, h6 { font-size: 12pt !important; }
|
|
</style>
|
|
|
|
|
|
|
|
<style title="hcp" type="text/css">
|
|
<!--
|
|
span.hcp1 { color:#c0c0c0; }
|
|
span.hcp2 { font-weight:bold; }
|
|
ul.hcp3 { list-style:disc; }
|
|
font.hcp4 { font-weight:bold; }
|
|
-->
|
|
</style>
|
|
</head>
|
|
<body>
|
|
<script type="text/javascript" src="../ehlpdhtm.js" language="JavaScript1.2"></script>
|
|
|
|
|
|
<p class="Help-Heading-1" style="background-color: #008000;">Add or Remove Report Columns</p>
|
|
<p class="help-text"><a href="../qbpos_basic_procedures/basic306.htm">Filter Report Data</a> <span class="hcp1">|</span> <a href="reports01.htm">Change Report Appearance</a> <span class="hcp1">|</span> <a href="reports02.htm">Modify a Report</a></p>
|
|
<p class="help-text"> </p>
|
|
<p class="Help-Note">This information applies to the <span class="hcp2">Add or Remove Columns</span> window, accessed when running or modifying a report.</p>
|
|
<p class="help-text"> </p>
|
|
<p class="Help-Text">Select columns to include in the report and set sorting and other options as follows. Select <span class="hcp2">Save</span> when done.</p>
|
|
<p class="Help-Text" style="font-weight: bold;"> </p>
|
|
<p class="Help-Text" style="font-weight: bold;">Columns</p>
|
|
<ul class="hcp3">
|
|
<li class="p-Help-Bulleted" style="margin-left: -20px;">
|
|
<p class="Help-Bulleted">Select the data columns to include on the report. A check mark indicates the selected columns.</p>
|
|
</li>
|
|
<li class="p-Help-Bulleted" style="margin-left: -20px;">
|
|
<p class="Help-Bulleted">Detail reports include a second tab to select the detail fields included.</p>
|
|
</li>
|
|
<li class="p-Help-Bulleted" style="margin-left: -20px;">
|
|
<p class="Help-Bulleted">On the report, columns are displayed in the order (from left to right) in which they appear in report options (from top to bottom). Drag and drop column names to place in the order you want.</p>
|
|
</li>
|
|
<li class="p-Help-Bulleted" style="margin-left: -20px;">
|
|
<p class="Help-Bulleted">Column order can also be rearranged directly on the <a href="reports_working_with_displayed.htm">displayed report</a> by dragging and dropping the column headers.</p>
|
|
</li>
|
|
</ul>
|
|
<p class="Help-Text">        <img src="../image/report_columnsplit.gif" alt="" style="border: none; margin-left: 8px; margin-right: 8px; margin-top: 8px; margin-bottom: 8px;" border="0"></p>
|
|
<ul class="hcp3">
|
|
<li class="p-Help-Bulleted" style="margin-left: -20px;">
|
|
<p class="Help-Bulleted">Comparison reports and the Inventory Summary with Activity report have a split column selection box. Use the upper box to choose what you want to compare (vendors, departments, months, specific items, etc.) and the lower box to choose the comparison metrics (typically cost, price, sales amounts, or quantities).</p>
|
|
</li>
|
|
</ul>
|
|
<p class="Help-Text" style="margin-top: 0; margin-bottom: 0; font-weight: bold;">Sort By</p>
|
|
<ul class="hcp3">
|
|
<li class="p-Help-Bulleted" style="margin-left: -20px;">
|
|
<p class="Help-Bulleted">Select the value by which you want the report data sorted. The sort determines how data is ordered and grouped on the report. For example, to see all data for a department grouped together, choose <span class="hcp2">Department</span> as the sort value. The sort column must be included in the report in order to sort by it.</p>
|
|
</li>
|
|
<li class="p-Help-Bulleted" style="margin-left: -20px;">
|
|
<p class="Help-Bulleted">Select the Create subtotals for this field check box to add a subtotal line to the report each time the selected sort value changes.</p>
|
|
</li>
|
|
<li class="p-Help-Bulleted" style="margin-left: -20px;">
|
|
<p class="Help-Bulleted">Report data can also be re-sorted once the report is ran and displayed by clicking the column headers.</p>
|
|
</li>
|
|
</ul>
|
|
<p class="Help-Text" style="font-weight: bold;">Sort In</p>
|
|
<ul class="hcp3">
|
|
<li class="p-Help-Bulleted" style="margin-left: -20px;">
|
|
<p class="Help-Bulleted">Select to sort in <span class="hcp2">A</span><font class="hcp4">scending Order</font> (AZ, 110) or <span class="hcp2">D</span><font class="hcp4">escending Order</font> (ZA, 101).</p>
|
|
</li>
|
|
</ul>
|
|
<p class="Help-Text" style="font-weight: bold;">Show</p>
|
|
<ul class="hcp3">
|
|
<li class="p-Help-Bulleted" style="margin-left: -20px;">
|
|
<p class="Help-Bulleted">Available only on certain Best/Worst, performance, and the Inventory Summary with Activity  reports.</p>
|
|
</li>
|
|
<li class="p-Help-Bulleted" style="margin-left: -20px;">
|
|
<p class="Help-Bulleted">On Best/Worst reports, select to view <span class="hcp2">A</span><font class="hcp4">ll Records</font> or only the <span class="hcp2">B</span><font class="hcp4">est/Worst</font> n <font class="hcp4">Records</font> (where n is a user-defined number). The available option here will depend on the Sort In method selected. This option can also be changed on a displayed report by clicking a column header related to the value used to rank the report (price, cost, margin, etc.) or by changing the number of records to be shown (on the report window toolbar) and then selecting the <span class="hcp2">R</span><font class="hcp4">efresh</font> icon.</p>
|
|
</li>
|
|
<li class="p-Help-Bulleted" style="margin-left: -20px;">
|
|
<p class="Help-Bulleted">On the Inventory Summary with Activity Report, select the checkboxes to include sales, receiving, and/or purchase order information.</p>
|
|
</li>
|
|
</ul>
|
|
</body>
|
|
</html>
|