Report Designer Installation Installing Report Designer for Cloud and Private Host (v5.x) is simple and can be completed in a couple of clicks....
Report Designer Report Designer is an Excel add-in that allows users to create reports within Solver. It is a full-blown Excel-based report writer...
Supported Excel Formulas This article details the Excel formulas that are supported within Solver Cloud Solver’s web interface supports many but unfortunately not...
Period and Date Calc Functions This article will detail how to create custom functions to allow you to bring in exactly the data you need. ...
Working with an Expanding Selection Group and Data Bars This article details how to get data bars working with an expanding selection group. Method This tip involves getting the...
Filtering by Week This article details how to filter and group by week within Report Design. Method To filter and group by week...
Filtering Trees This article details the process of filtering trees. Method You can set up multiple trees per Dimension. If you make...
Protecting Specific Cells in Excel This article details how to protect/lock cells in Excel that are populated when run in Report Designer. Note: This was tested...
Retrieving Deleted Report Templates This article details how to possibly retrieve deleted report templates. Method As of right now, there is currently no ‘undo’...
Retrieving the Original Excel Report Once it Has Been Corrupted This article details how to retrieve an original Excel file after it has become corrupted. If the report was saved...
Saving a Cloud Report to a New Location This article details how to save a Solver Cloud or Private Host report to a new location. When creating a...
Filtering Blank Worksheets with Parameters and Lookup Filter This article provides details on filtering blank worksheets with parameters and the lookup filter. If you would like to use...
Period Aggregation Solver Reporting has a new feature called “Period Aggregation” in Layout Editor and this article provides more foundational knowledge. Here...
Report Properties Menu – Reporting & Budgeting This article details the Reporting and Budgeting tabs on the Report Properties window found in the Report Designer ribbon in...
Using Comparable Data in LID Spreads for Budgeting This article details how to use the previous year’s Actuals in Line Item Detail spreads for budgeting. When designing Planning...