Getting the Most Out of Your Xcelsius 2008
How do you get the most out of your Xcelsius 2008, one of the world’s most popular visualisation tool for creating interactive visual models based on highly aggregated data sets? Look no further and download this best practices guide that covers the best practices for designing Excel models, dashboards, and visualisations, as well as for Flash security.
Download Now | Back To Top |
How To Create Data When Dates Are Missing In Crystal Reports?
This report uses a series of formulae, including two arrays, to create data that is not present in the database.
The two arrays are then shared with a Report Footer Subreport, which is used to display all of the required dates and corresponding data for the date range.
The formulae on the main report that are required to create the date range data are:
{@reset}, {@counter}, {@Date Array1}, & {@DateArray2}.
These formulae contain comments on their functions.
Instructions:
1.) Copy & Paste (or Drag & Drop) the formulas in the Formula Fields section onto your report.
2.) Update the report fields to those in your database.
Note: The {@dates between} formula is used for displaying the dates that are missing in the range. It is not necessary to recreate this formula.
Note: The main report Details sections can all be suppressed. The Report Footer subreport would remain unsuppressed as it is used to display the final data.
| Back To Top |
|