hello all,
Hoping someone who may have already built something similar can help me with an SSRS issue. I am having trouble articulating it, so haven't been able to find a solution in the usual places (stack overflow, etc).
Basically, using a combination of order, booking, and custom data, I need to create a report that resembles a daily calendar view in outlook, with the appointment box stretching from the start time to end time. I've already got a good basic calendar set up (table nested in a matrix in SSRS), but everything is only listed by start time. I want it to be visually obvious where the overlap is. My custom proc includes end time data as well, so it's available, I just don't know how to do it
Anyone have any ideas?
Sheila
Thanks for the feedback, Troy Nelson and Chris Jensen.
Chris, what you're describing is sort of similar to how I do monthly calendar reports in SSRS. I make a 5 x 7 matrix, grouped by week of month vertically, and day of week horizontally, and then insert a multi-row table INTO the data area of the matrix for the actual appointments-- this keeps it looking tidier, for sure, and allows for multiple appointments each day. For a monthly calendar, it works quite well.
What I ended up doing for this daily view that I wanted (Troy, like you, I was doing this for some resource scheduling) was to create a range column chart in BIDS, and display the data labels for each bar. Then I reformatted the labels to contain the actual data I was after, widened the columns, and reformatted them to make the draw side-by-side attribute false. I made the x-axis the spaces, and the y-axis the start time, and then reversed the data so it displayed in the order I wanted.
That all sounds kind of convoluted, but in the end, it did pretty much exactly what I wanted, so I am happy with it. Here's a little screenshot to give you an idea of how it turned out.
Thanks again!