My main report is a list of land acquisitions, along with their closing dates. Each land acquisition has a single record in the main report.
The data table used in the main report includes a datetime field. Instead of using that date-time field in the report, I have created a formula that converts it to a date field:
I then created a subreport that lists money spent on acquisitions, and there can be multiple records in the subreport for each record in the main report.
In the subreport I created a similar formula:
I want to limit the records in the subreport to just those records that have a date equal to or greater than the date in the main report.