The listing report displays all the information you have entered for a lease, as well as classification results. Please note that unlike most reports, the listing report by default displays only the final revision. To display all revisions, go to Special Options and change Use Revisions from Final to All.
Report options unique to this report:
Check this box to display any picture attachments for each lease. This may create substantial additional output. This is ignored for spreadsheet output.
Each lease on new page
Check this box to start each lease on a new page, rather than immediately following the prior lease on the same page. This is ignored for spreadsheet output.
Combine rent for linked leases
This option is found on the Special Options window. It combines the rent for linked leases (usually finance and operating components of a single billed lease).
All information you have entered for the lease is displayed. If you have multiple revisions (and have chosen to display them), the financial information that changes with each revision is listed first. Following all the revision information, the descriptive information and other information that is the same for all revisions (such as variable lease payments and notice dates) is listed.
Please note that attachments may be distorted, because the report writer is unable to adjust for attachments of differing sizes. To get a better quality, undistorted print of an attachment, use the Print Attachment(s) button of the attachments screen for the individual lease.
The spreadsheet format of the listing report contains multiple tabs. The first tab, titled “Main,” contains all the information for the lease that only exists once per lease. The next tab is “Rent,” which contains the regular rent steps. Following that is “Options,” “Variable Lease Payments,” then “Notice Dates.”
You can put values from the Main tab into cells on the other tabs by using the following Excel formula: =VLOOKUP(A~row~,Main!A6:DQ~last~,~col~)
Replace ~row~ with the row number that you are on, ~last~ with the last row in tab Main, and ~col~ with the column number in Main that you want to display. (Check your spreadsheet for the last column used, represented by “DQ” here; the actual last column will vary depending on how many user-defined fields you are displaying and certain other variables.) For instance, to put the Description on row 6 of the Rent tab, you could put into cell M6 the formula: =LOOKUP(A6,Main!A6:DQ200,2)