0

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

null
    • Fred
    • 8 mths ago
    • Reported - view
     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?

    • Alina_Morgovsky
    • 8 mths ago
    • Reported - view

    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. 

    • John_Halls
    • 8 mths ago
    • Reported - view

     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

      • Alina_Morgovsky
      • 8 mths ago
      • Reported - view

       you’re right. It is the relationship I was using . 

Content aside

  • 8 mths agoLast active
  • 4Replies
  • 147Views
  • 4 Following