AnsweredAssumed Answered

Report

Question asked by DanielJenkins on Feb 3, 2015
Latest reply on Feb 4, 2015 by DanielJenkins

Title

Report

Post

I have created a report which displays data from my booking table.
It displays Booking ID, Accommodation Type, Arrival Date, Departure Date and Customer ID.
It sections the data by accommodation type.
In addition to this, I've create a script which runs when I click a button on my main menu, the script is to open this report and only show bookings within 'Winter'. I have also created a report for bookings within 'Summer'.

The script i've used is:
Enter Browse Mode []
Go to Layout ["Winter Bookings" (Customers)]
Perform Find [Restore]
Sort Records [Restore; No dialog]

The script for the find is:
Field: Bookings::Arrival Date 
Criteria: <=30/09/2015
AND >=01/04/2015

Currently, it is not performing this find correctly.
Can anyone offer any advice as to what I need to do? 
Also how can I display all the records on one form? Currently one set of records is displayed per form.
I have attached a screenshot illustrating what is currently displayed

Thanks, Daniel.

 

Screen_Shot_2015-02-03_at_19.21.49.png

Outcomes