AnsweredAssumed Answered

Summary Report Part II

Question asked by disabled_rosalie on Jan 7, 2015
Latest reply on Jan 15, 2015 by disabled_rosalie

Title

Summary Report Part II

Post

 Hi Everyone,

Here I am again, 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.

 

Outcomes