Creating with InterjectEstimated reading time: 7 minutes
This section is for report writers who need to create or modify reports. You will run through basic modification, creation, and publishing of reports. Feel free to contact us if you cannot find your answer in these sections.
A Lab Guide is offered to guide you through learning about the Interject features step-by-step. As you work through the labs, you will see this blue banner on documentation pages that lead you to the correct file for that particular page. If you are new to the Interject Add-In, these labs are a great place to start!
Reporting needs change often. Account details, specific formatting, even spreadsheet formulas require modification, that is why Interject's reports are so highly customizable using familiar spreadsheet knowledge. This section walks through common report modifications using Customer Aging, Inventory, and Financial reports as an example.
This section details how to create reports from scratch. Here, you will walk through making a Customer Aging and Customer Orders report from the ground up. The focus is on using simple single range tabular reports.
Reports often require various formats and subtotal sections, and this is especially true for financial reports. This section goes through several, more advanced report examples: Inventory, Financial and Customer Aging Detail. These will illustrate how Interject provides a number of options for your reporting needs.
Creating drills, it is possible to generate a simple suite of reports that enable you and your end-users to navigate anywhere from within the spreadsheet environment. Examples in this section include building drills in a Customer Aging, Inventory, and Financial report. Also included is drilling to a separate workbook. There is more than one way for the user to interact with the drill feature. See the page Three Ways to Drill for more details.
ReportHideRowsOrColumns() is a function that allows you to hide both rows and columns when not needed. In this example, you will begin with hiding columns L, M, N, and O. To practice there is a file below that has been specifically prepared for this formula.
When manually entering different filter values, it can be difficult to remember what the exact filter names are and which are even available. This is especially true in large reports with many filtering options. However, you can use Interject’s jDropdown formula to automatically create hyperlinked lists of available filters, which makes filtering in large reports a much simpler task.
Pivot tables are excellent tools to help us find answers quickly. Interject can help simplify pivot table presentation and distribution.
Special Column Definitions are optional tags that bring out additional features to your standard column definition rows. They are great for space savers or to allow for faster formatting of the Pulled data.
Sheet Protection expands upon the already existing protection functions in excel but brings with it the Interject UI and security rights.
To use it, navigate to the Interject ribbon and click on the Sheet Protector button in the Tools section.
The Report Macro function allows Interject to interact with public macros in Excel. These macros can be automatically run after pulling or clearning data.
When using Interject to pull data into your spreadsheet, the report area will be cleared before new data is inserted. In some situations, you may want to bypass the clear action and retain some formulas, since pulling could remove formulas you have on other columns related to certain data rows.
Some reports require default values, settings, or have summary pages that must be pulled before others in order for the report to function properly. Using the Run on Open Interject property will auto-run the first tab that appears.
Interject reports can be published or exported when needed. In most situations, Interject reports are shared like a web page, where all end users have access but can only see cost centers they have rights to. Still, there are times when reports must be saved to file folders or emailed, and this section walks through the specifics of distribution and all the available methods.