Given Data
Activities by employees with start dates and end dates in a mySQL database.
Objective
User Mon Tue Wed Thu Fri Sat Sun Total
--------------- ------- ------- ------- ------- ------- ...
... a Matrix rather than a Tablix:
Insert a "Matrix" into the body of your report.
Drag "ReportName" into the field that says "Columns".
Right-click on the grey left margin and select "Insert Row" then ...
... a new report:
We're going to run the wizard here but without it just add a matrix with [time] in the "column" and [room] in the "row" and [note/status] in the "data" cells.
2. Use the SQL ...
... -- date used in all calculations for date
d.[Date],
--generates matrix columns
[WeekDay] = DATEPART(WEEKDAY, d.[Date]),
--used to display day of month on calendar
[Day] = DATEPART(DAY,d.[Date]),
...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.