disabled_rosalie

Crosstab Reporting

Discussion created by disabled_rosalie on Jan 8, 2015
Latest reply on Jul 17, 2015 by kaostika

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.

Attachments

Outcomes