Standard Sage Intelligence reports have their settings automatically placed on Sheet2 at runtime. One of the settings included on that sheet is the Run On date which shows the date and time when that instance of the report was run out. That is very useful for many reasons! For example, sometimes I need to use the date that a report was run in a formula. Or, sometimes I like to include the date and time that a report was run in the heading of the presentation sheet that end users see. That lets them know exactly when the data that they are viewing was pulled from the database.
Report Designer Add-In reports do not have a settings sheet and unfortunately do not include the date and time that a report was run out. This means that for the RDAI reports we have to jump through hoops in order to automatically include a date/time stamp in a RDAI report heading. Excel provides the Now() function, which of course is of no use for this purpose because it's dynamic. Excel provides 'Ctrl+;' and Ctrl+Shift+;' but of course those don't help either since they are manual. Some other approaches I've seen to automatically get a date/time stamp on a worksheet involve either changing the formula iteration setting or using VBA.
Please add a worksheet to the RDAI report that contains the date and time that the report was run. Even if that is the only value on the sheet and you name the sheet RunOnDate, that would be fine. We just need the date and time that a report was run out to be available in RDAI reports. Thanks!

by: Ralph A. | over a year ago | 4 - Reports / BI