The CREPORTDATE formula is used to show a date picker on your published report that is independent of a cube data point.
Important Note: The setup of Windows on your CALUMO Server can dictate the default date format that this formula uses to write back in Published Reports. If you notice your values being written back in a different format, have your I.T. Department investigate the following registry key on your CALUMO Server.
HKEY_USERS\.DEFAULT\International\sShortDate(Set this to your desired format, e.g. dd/MM/yyyy)
CREPORTDATE (Date, AutoCalc)
Specify the date that you want to start with, and set the cell format to Date (unless a serial number is required)
A True/False value to specify you want the report to calculate when this cell is changed.
Default value: false
To produce a date picker on your published report that is independent of a cube data point.
When published, a date picker is displayed to facilitate data entry. All the arguments are compulsory.
Cell B2 has the formula:
=CREPORTDATE(TODAY()), and cell is formatted as _dd mmm yyyy_
When published, the current date shows (in yellow). The currently selected date will show in brown. Once new selection is made, press F9 to refresh and write selection.