1,309
edits
Changes
no edit summary
sqlReport - Room Utilization from Valley
Matrix view with rooms on left side and a column view for each period with totals per period. Unused rooms show a blank.
WARNING! This report uses pivot, in SQL pivots need to have the columns "hard-coded". This report is code for
1(A), 2(A), 3(A), 4(A), 5(A), 6(A) and 7(A) as expressions. You will need to modify for your own use.
Matrix view with rooms on left side and a column view for each period with totals per period. Unused rooms show a blank.
WARNING! This report uses pivot, in SQL pivots need to have the columns "hard-coded". This report is code for
1(A), 2(A), 3(A), 4(A), 5(A), 6(A) and 7(A) as expressions. You will need to modify for your own use.
