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
Sheila Kearney Miller said: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.
A big challenge in SSRS. Calendars in general are tough in SSRS, since it wants to widen and lengthen things as per the data it is enclosing, which will sprawl your page in all directions and make the whole thing unprintable, if not unreadable.
The closest I got to getting something like this to work was to create a fixed table seven columns wide by six rows high, filling the days as per the month in question, graying out the unused days, etc.. Tedious, and it didn't solve the "I want it to be visually obvious where the overlap is" issue. We never rolled it out.