Hello,
I have a layout that show a records in a date range ( StartDate; EndDate ) it's also display the date format range in the header of the layout e.g records " from 1.1.2017 TO 1.15.2018".
how can I hide the display date format if I select Show all Records from being showing in the layout header ?
or is it possible if I select show all records it will show the dates of the first records and the date of the last rerecords range
any help ?
Get ( FoundCount ) = Get ( TotalRecordCount )
Will be true only if all the records in your table are also in the current found set--the result you get with Show All Records. So you might use the above in a "Hide Object When" expression.
Presumably, you could also get all records by specifying a large enough date range, so you may need to do more if that's a concern.
Other options: If you use a script to take the specified dates and find your records, that script could set a global variable to a value and OnLayoutExit might be used to clear the variable. Then your dates can be hidden if the variable does not have the specified value and the dates will only show if you navigate to the layout without using the script to find records.