AnsweredAssumed Answered

Reports_Crosstab

Question asked by disabled_rosalie on Aug 4, 2015
Latest reply on Aug 7, 2015 by philmodjunk

Title

Reports_Crosstab

Post

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
FieldsTypeComments
UserIDNumberIndexed, Auto-enter serial
AccountNameText 
CreationAccountTextCreation Account Name, Can't Modify
First NameText 
Last NameText 
FullNameCalculationFirstName & " " & TextStyleAdd(LastName; Bold)

 

DailyReports Table

 

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
FieldsTypeComments
DailyReportsIDNumberIndexed, Auto-enter serial
DailyReports_UsersIDText 
DailyReports_UserName Indexed, Creation Account Name
ProjectCodeText 
DateDate 
ActivitiesText 
ActivitiesTimeNumber 
Activities Time SummarySummary=Total of Activities Time
Month_1DateGlobal
Month_2CalculationUnstored, from DailyReports,= Date ( Month ( Month_1 ) + 1 ; 1 ; Year ( Month_1 ) )
Month_3CalculationUnstored, from DailyReports,= Date ( Month ( Month_1 ) + 2 ; 1 ; Year ( Month_1 ) )
Month_4CalculationUnstored, from DailyReports,=Date ( Month ( Month_1 ) + 3 ; 1 ; Year ( Month_1 ) )
Month_5CalculationUnstored, from DailyReports,=Date ( Month ( Month_1 ) + 4 ; 1 ; Year ( Month_1 ) )
Month_6CalculationUnstored, from DailyReports,=Date ( Month ( Month_1 ) + 5 ; 1 ; Year ( Month_1 ) )
Month_7CalculationUnstored, from DailyReports,=Date ( Month ( Month_1 ) + 6 ; 1 ; Year ( Month_1 ) )
Month_8CalculationUnstored, from DailyReports,=Date ( Month ( Month_1 ) + 7 ; 1 ; Year ( Month_1 ) )
Month_9CalculationUnstored, from DailyReports,=Date ( Month ( Month_1 ) + 8 ; 1 ; Year ( Month_1 ) )
Month_10CalculationUnstored, from DailyReports,=Date ( Month ( Month_1 ) + 9 ; 1 ; Year ( Month_1 ) )
Month_11CalculationUnstored, from DailyReports,=Date ( Month ( Month_1 ) + 10 ; 1 ; Year ( Month_1 ) )
Month_12CalculationUnstored, from DailyReports,=Date ( Month ( Month_1 ) + 11 ; 1 ; Year ( Month_1 ) )

 My Two tables are connected by UserID  = DailyReports_UserName

I made a Table of Occurrence of my DailyReports table and I named it DailyReports_ProjectCodes_Users and is connected to my DailyReports table by ProjectCode (=)

I also created a layout and I named it ProjectCodes_Users which I have a Layout Parts Subsummary when sorted by DailyReports_UserName and  Subsummary when sorted by ProjectCode. Also under this layout I have a also setup a single portal showing related records from DailyReports_ProjectCodes_Users (DailyReports_ProjectCodes_Users::ProjectCode = "DMF") and I put a field Activities Time Summary

Is there a way that That I can Catch the UserNames to be on the top of my report like the attached?

 

Thank you so much

 

 

Untitled.png

Outcomes