Limit sub report records to a time range on main report 1

[nerdygirlgear]

I am working on getting a sub-report to display records related to the dates in the main report parameters, but it's complicated by the detail table in the sub-report.

The table is organized in ascending order by DateTime and its only useful key is the MemberID. The detail table tracks sessions during a visit with a start and end time, the type of session, a sessionid (which does not link to anything), and a member ID. There is no real way to link the sessions connected to a visit other than saying it is >=checkindate and <=checkoutdate. I tried a formula that would exclude incomplete records, meaning there's no check-out date. Other than that, I am having a hard time keeping the sessions in line with the right visits.

Any recommendations would be appreciated.

 

[hilfy]

Have you tried passing the checkin date and checkout date as subreport links? At that point they become parameters in the subreport that you can use in the filter.

-Dell

Associate Director, Data & Analytics
Protiviti

http://www.protiviti.com