3 Replies Latest reply on Apr 18, 2013 4:52 AM by JimMac

    Create a report template with per day/per unit results

    OguiiFoguii

      Title

      Create a report template with per day/per unit results

      Post

      Dear all,

           I am designing a database for harvest records. I have used simple statistics to get totals at the bottom of my data. Easy.

           I am now creating two templates for a report per block and another report per day. The report per block contains the same simple statistic (totals), just in a print-friendly format.

           Now, it is likely that several blocks get picked on a given day and processed together. Therefore, I need to create a report per day that will group all the results from several fields in a single line.

           It would show something like:

           Field day > narrows down the result to 1 day per entry

           Field quantity > calculates total quantity from all the blocks picked on that day

           Field block > shows ""Block A & + & Block C & ..." that were picked on that day

           Field traceability > narrows down to a traceability number that is unique for each day (but common to many blocks in my other templates)

      Not sure of the calculation for this... I've dug through help and manuals but could not quite figure out the way out of this. The image attached shows the report per block.

      Your help is much appreciated,

      rapport.jpg