8 Replies Latest reply on Jul 17, 2015 7:57 AM by kaostika

    Crosstab Reporting

      Hello Everyone,

      I need some guidance,  before that I want to give some info regarding my database that Im working on. Im am trying to make all my excel report to a Filemaker.

      Below are the info of my Two tables

      Time Table
      Field NameTypeOptions/Comments
      idTextIndexed, Auto enter Calculation (Get (UUID)
      CreationAccountTextIndexed, Creation Account Name, Can't Modify Auto
      AccountNameCalculationUnstored, = Get (AccountName)
      ID_timeTextIndexed, Auto-enter Serial
      Date_createdDateCreation Date, Can't Modify Auto
      Date_modifiedDateModification Date, Can't Modify Auto

       

      ProjectsTable
      Field NameTypeOptions/Comments
      IdTextIndexed, Auto enter Calculation (Get (UUID)
      CreationAccountTextIndexed, Creation Account Name, Can't Modify Auto
      AccountNameTextUnstored, = Get (AccountName)
      Id_projectTextIndexed
      DateDateDate
      ActivitiesTextIndexed
      Activities_timeNumber
      Activities_summarySummary=Total of Activities_time
      Lot_No.TextIndexed
      Project_CodeTextIndexed
      EquipmentTextIndexed
      Equipment_timeNumber
      Equipment_summarySummary=Total of Equipment_time

      My two tables are connected with a relationship ( Time::ID_Time = Project::Id_project)

      I've been trying to make a summary like the attached image but I didn't get any luck.

      Please push and direct me to achieve the report that I want.

      Thank you so much in advance.