Print filtered by date and assigned employee records from the table
Hello, I have a table named “Report” that’s where all the records stored, records have an assigned “drivers” and “pick up date field”. I need to be able to generate a weekly report for the driver that would show his weekly totals. As of now I have a relationship from “Report” to “Driver” , Start Date and End Date fields, formula field (which calculates salary based on start and end dates) and image field for pdf. But in order to make weekly reports, each time , besides changing Start and End dates, I also have to filter “pick up date” in the view of “Report” , and in the print layout as well. I can’t figure out an easy way to do that. I’d like those dates to be filtered simultaneously . Please, let me know what would be the most convenient way to get it done? Thank you
4 replies
-
said:
I also have to filter “pick up date” in the view of “Report” , and in the print layout as well.So Report is a view element to the Report Table? What is your code in the view element?
-
I actually figured it out already. I put formula on date in both view element of Report and print layout and it’s working now.
-
Did you get your view to print out correctly? My understanding is that views don't print well and it's better to link the records you need to a parent and print using that relationship.
Regards John
Content aside
- 9 mths agoLast active
- 4Replies
- 147Views
-
4
Following