Newbies filemakermonster Posted February 24, 2018 Newbies Posted February 24, 2018 I have a file that contains records that have a beginning date field and a ending date field. My summary report is working, it is breaking as it should and contains subtotals and a grand total. My problem is I want to report records that are between a user entered beginning date and ending date. How do I get those dates and use them to run my subsummary report?
doughemi Posted February 24, 2018 Posted February 24, 2018 Create two new global fields UserStartDate and UserEndDate and place them on a layout. Create a script If[not isEmpty(YourTable::UserStartDate) and not IsEmpty(YourTable::UserEndDate)] Set Field[YourTable::EndDate; YourTable::UserEndDate] Set Field[YourTable::StartDate; YourTable::UserStartDate] Set Field[YourTable::UserStartDate; ""] Set Field[YourTable::UserEndDate; ""] Go To Layout["YourSummaryReportLayout"] End if Attach a script trigger OnObjectExit which calls this script to both the UserStartDate and UserEndDate fields on the layout.
Recommended Posts
This topic is 2819 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now