As with SmartList Builder, Excel Report Builder is another powerful tool in our reporting toolbox. Though many of the same concepts that exist for SmartList Builder hold true for Excel Report Builder, we are not building a new SmartList Object that will be accessed through SmartList. Instead, as we discussed earlier in the chapter with the deployment of Excel Reports, we are creating our own Excel Reports, Office Data Connections, or both.
The advantage this tool gives us is that we can designate that our resulting report will either be a simple list of data or it will be a Pivot table in Excel. It basically takes out the step of our users needing to first extract the list of data, and then create the Pivot Table. Essentially, the user will open the resulting Excel file and be provided the fields they can select in their Pivot Table. They will not be provided with the list of raw data, but instead will select their...