This page describes a part of the Mobile Dashboard's process for configuring reports. For an introduction to the report configuration process, see Section 5.1, “Introduction To Report Configuration”. For an example of how a report can be configured, see Section 5.28, “Report Configuration Example”. For a general introduction to the online help manual, see Section 1.1, “Mobile Dashboard Online Help Manual Overview”.

You are now beginning to define the boundaries of the spreadsheet data item, i.e., the top, bottom, left and right boundaries, as well as columns and rows you want skipped and not displayed on mobile devices.

The first step in this process is to select a cell in the spreadsheet that identifies the upper-left corner of the data you want displayed. This provides both the top and left boundaries of the spreadsheet item.

One important consideration is to set the upper left corner high enough and far enough left in the spreadsheet to include all cells where potential data could occur for all rows and columns containing your headers. Sometimes a row header is placed above the top line of data (i.e., the row cells are empty), or sometimes a column header is placed left of the first column of data (i.e., the column cells are empty)> In these situations you will need to mark a cell that includes those rows and columns. Often, all column headers directly above data, and all row headers are directly left of data, so you can then just mark the upper-left corner of the data itself.

Important: if your spreadsheet has multiple worksheets, be sure to select the worksheet you want to work on here. You will likely create multiple items for multiple spreadsheets so please pay attention to setting the Sheet (shown just above the spreadsheet itself) you want to configure.

When you select a cell from the spreadsheet, the Upper-left Corner field populates with the cell location you selected.