July 2015
Intermediate to advanced
288 pages
7h 26m
English
Figure 5.9 shows the Show/Hide Columns drop-down menu. This useful feature is for getting the data grid into the order and appearance needed for the final output of the data. Use the View/Edit Query button to show the SQL used to create the current data grid. The Export Dataset button and report button will use the data and columns that appear in the data grid and in the order that they appear in the data grid. This feature is one way to remove unwanted columns from the output, no matter if the output is Export Data, Report Printing, and so on.
FIGURE 5.9 Show/Hide Columns drop-down menu
You can drag and drop the columns by ...
Read now
Unlock full access