1. A system for creating a report in a spreadsheet, the system comprising: a central processing unit; and a memory encoding instructions that, when executed by the central processing unit, cause the central processing unit to create: a data source module programmed to identify sources of data items associated with the spreadsheet; an active module programmed to generate the report including a portion of the data items associated with the spreadsheet, and identify which of the data items are associated with the report; and a display module programmed to display a field pane to modify the report, the field pane including an active tab and an all tab, the active tab displaying those data items that are determined to be associated with the report, and the all tab displaying all of the data items associated with the spreadsheet.