This article will describe a few simple features of Teradata SQL Assistant that can help you to create an eye-catching report or email.
When working with the Answerset or History windows the Copy menu will copy the highlighted data as Tab Delimited text.
If you paste this into an email, or other document, it will generally result in data values that lose their column alignment.
You will also lose the alternating background colors and any other formatting you may have applied.
If you want to keep the formatting, and the appearance of a table, simply use Copy as HTML instead.
Note that this will only work if the application you are pasting the data into expects HTML text to be available in the clipboard.
Both Microsoft Word and Microsoft Outlook expect HTML text to be available.
In version 14.01 of SQL Assistant we added simple but powerful charting capability to the application.
If you wish to chart a contiguous block of cells you can simply:
In this case the first column selected will be used for the X-Axis labels and the remaining columns will form the data series.
If the columns you wish to chart are not contiguous then:
You may change the chart type, or any other property, by right clicking on the displayed chart and then clicking Modify.
You may also change the angle of rotation or elevation in order to highlight some aspect of the chart. This can be done either through the context menu or by using Ctrl + the arrow keys.
You may also use Ctrl + or Ctrl - to zoom in/out on a portion of the chart.
To copy the chart to a document, or email, simply use the Copy menu, or Ctrl+C.
The Format Cells ... menu can be used to change the appearance of individual cells, rows, columns, or blocks of cells. Simply highlight the cells that you wish to format, right click, and then click Format Cells ....
This will display a dialog that allows you to change:
Here we have described a few ideas that will help you to use SQL Assistant to create more informative documents and emails.