MyWraps is the powerful ExcelWraps reporting system. It creates a filtered and sorted list of Wraps in the form of tables and charts. Developers can feed filtered and aggregated wrap data into other wraps using the MyWraps2 function. Administrators can manage wraps using a filtered list.
MyWraps displays cell values in selected Wraps as charts or tables. Reports can be filtered, sorted, and ordered to give you exactly the information you require. Aggregation functions allow you to perform calculations across the whole data set.
MyWraps reports and wrap data can be imported into Excel for advanced analysis.
MyWraps can be called from inside a wrap with the MyWraps2 function. This enables wraps to read also large amounts of data from other wraps, and to include wrap data in tabular format using the ShowTable function.
The fine granularity of the MyWraps filtering system makes it useful for Wrapsite administrators to perform some wrapsite maintenance from inside MyWraps, e.g. to print, recalculate, freeze, export, or delete wraps.
These are the help pages that document the MyWraps reporting functionality:
MyWraps is located on a separate tab on the start page of your Wrapsite. Navigating to MyWraps will present a list of the Wraps that are available to you.
This tab contains a list of your Wrap templates.
The Creator filter allows you to view only the Wraps that are created by Me (the logged-in user) or Any (created by anyone). Read more in the help for the Creator filter.
The State filter lets you select only the wraps that are Live or Frozen, awaiting a signature or signed by you. Read more in the help for the State filter.
You can also filter the list by entering any part of the Wrap’s name in the Name text box and press Filter.
Click on the Wrap template you want a report from.
MyWraps operates under the ExcelWraps permissions model.
Once you’ve selected the wraps that form the source data, you can filter the list of wraps and sort the report.
The buttons in the toolbar allow you to perform additional manipulations on the table:
A Wrapsite administrator with the AdminTenant role can create custom reports for users using a few additional buttons that appear in the toolbar:
The Action button in the MyWraps toolbar opens the Action dropdown menu that lets you perform actions on the selected wraps. Additional actions appear if you are a Wrapsite administrator. Some actions are deactivated until you select at least one wrap in the list.
For more information, visit the MyWraps actions help page.
The interactive part of MyWraps is essentially a link builder. Any MyWraps report can be saved as a single link that can be stored as a browser bookmark, added as a hyperlink on a webpage, or added to the main menu for the Wrapsite. Your Wrapsite even includes a MyWrapsGenerator Wrap that can be used to create most reports you need, in the form of MyWraps links.
https://guide.live.excelwraps.com/MyWraps/WrapOne?Options.Creator=Any&Options.State=Live&Filter.yourname=Rachel
If we decompose a MyWraps link into its components, we find:
This is an overview of all the possible parameters in a MyWraps link and their defaults.
Each cell is referred to as <field>.<datatype>.<format>, e.g. partcost.double.f2.
To use a different column header, i.e. have an alias name for a column, specify the field as <Column+header>(<fieldname>).<datatype>, e.g. Policy+Issue(Issue).string.
You can also use the cell coordinates from the source spreadsheet to reference a cell. The format for such a cell reference is [Column name](sheet[sheetno][cell coordinates]).datatype, e.g. Birthday(sheet2c3).date would refer to cell C3 in the second worksheet (regardless of its actual sheet name) with an alias column name of Birthday and a data type of Date. Note that the cell reference must be entirely in lowercase, e.g. “sheet2c3”.
MyWraps attempts to group the keyword parameters in the link in a particular order for clarity. This order is predefined and cannot be changed. Links that have the parameters in a different grouping or order will still work as expected, but if the report is edited in MyWraps, the parameters will be placed in the predefined order, regardless of what order they were in initially.
The ExcelWraps Client Services team uses powerful database reporting tools to make any report no matter how complex. These reports can be made available through your Wrapsite. Don’t hesitate to contact Client Services if you need our help.
Since MyWraps is intended for administrators, there may sometimes appear to be room for improvement of the user interface. If unexpected conditions occur, they may be presented to the developer as
Before you contact Client Services, please make a quick pass through the data you have entered to ensure that there are no errors. As an example, entering a column filter as “gte(5)” instead of “ge(5)” for a greater-than-or-equal comparison will result in the error message above.
The pageSize setting for a Wrapsite, and the maximum value for it, are described on the MyWraps pagination help page.
