Skip to Content
Former Member
Apr 05, 2016 at 08:20 PM

How to limit subreport results based on a formula in the main report



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.