[Solved] Adding Selected Date Range to Report Title

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
AmyBUK
Posts: 12
Joined: Tue Nov 06, 2018 6:36 pm

[Solved] Adding Selected Date Range to Report Title

Post by AmyBUK »

Hi

I've created a query to show records that fall within a date range selected by the user so that when you open the report, it asks for the dates, and provides the records within that date range.

Is there any way to add the 'Datefrom' and 'DateUntil' dates to the report in the header as part of the title?

Many thanks
Last edited by robleyd on Fri Nov 09, 2018 11:49 pm, edited 2 times in total.
Reason: Add green tick [robleyd, Moderator]
OpenOffice 4.1.5 on Windows 7
Nocton
Volunteer
Posts: 533
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: Adding Selected Date Range to Report Title

Post by Nocton »

Create a 'Formatted Field', set 'Data Field Type' to 'Field or Formula' and then set the 'Data field' to the Start/End Date.
Of course the table or query which is the data source for the report must contain the Start and End dates that you wish to appear in the report.
OpenOffice 4.1.12 on Windows 10
AmyBUK
Posts: 12
Joined: Tue Nov 06, 2018 6:36 pm

Re: Adding Selected Date Range to Report Title

Post by AmyBUK »

Thanks - that's perfect.
OpenOffice 4.1.5 on Windows 7
Post Reply