[Solved] Adding Selected Date Range to Report Title

Getting your data onto paper - or the web - Discussing the reports features of Base

[Solved] Adding Selected Date Range to Report Title

Postby AmyBUK » Fri Nov 09, 2018 10:53 am

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
AmyBUK
 
Posts: 10
Joined: Tue Nov 06, 2018 6:36 pm

Re: Adding Selected Date Range to Report Title

Postby Nocton » Fri Nov 09, 2018 2:19 pm

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.2.0 on Windows 10
Nocton
Volunteer
 
Posts: 492
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: Adding Selected Date Range to Report Title

Postby AmyBUK » Fri Nov 09, 2018 3:26 pm

Thanks - that's perfect.
OpenOffice 4.1.5 on Windows 7
AmyBUK
 
Posts: 10
Joined: Tue Nov 06, 2018 6:36 pm


Return to Reporting

Who is online

Users browsing this forum: No registered users and 3 guests