Report filtering woes

[bruceiow]

Hi All,

 

I am having issues with a report that I am trying to create. I have a report up and running and showing almost what I want, but a date constraint I have put on is just not working!!

 

Here is my ERD:

 

 

The basic crack is that I want to show a report of USERS, with a portal containing their JOURNEYS. I have built my report with the USER table as the basis, with a portal based on the CLAIM table, showing Journey::fromId , Journey::toId and "date" from CLAIM.

 

The report is nearly complete, but the date script doesn't work:

 

Enter Find Mode []

Set Field [Claim::date; GlobalDateFind::GlobalStartDate & "..." & GlobalDateFind::GlobalEndDate]

Perform Find[]

 

This script is fired ok when the report loads, but I get records displayed on the portal that are not within the date range I have specified. 

 

Can anyone help me get this report finished please.

 

Many thanks

 

 

 

[Steve Martino]

You may need to filter the portal or relationship