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

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

211 Views

Hi,

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:

date({LR_TRANSACTION.CLOSING_DATE_TO})

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:

date({LRS_EXPEND.POSTED_DATE})

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.

Ideas?