Crystal. Dynamic Diary/Schedule view. 1

[HelpIts2010]

Many thanks in Advance.

I’ve been asked to print a report which displays diary based values for 1 day over 10 minutes intervals, hours are
7-12 - 12-5 and can be for max of 8 people.

Working landscape, left to right, each person will have a block on 2 pages, first page am, second page pm, with the above stated times.

Various appointments can be made for the same time, they have to be shown side by side. A booking should dynamically expand and cover the time of that appointment as a block containing details of the appointment.

Does anyone know if this is possible?

If so - how can I dynamically resize entries across various time slots side by side?

I've seen several posts many along the lines of the following;

"It's fine for tabular data and graph data but not really suitable for a graphical representation of a diary/scheduler."

Any suggestions, help or examples would be appreciated.

Thanks.

 

[lbass]

Do you have a table that includes all of the datetime 10-minute intervals? For the diary, you could group on the datetime field on change of a formula:

if hour({table.datetime}) < 12 then "AM" else
"PM"

...with a group #2 on datetime on change of hour and a group #3 on:

truncate((minute({table.datetime})-1)/10)+1

Then insert a subreport linked on these groups into the detail section. Add the appointment details to the subreport. Format the detail section in the main report to "format with multiple columns"->layout->set width and gap to allow for maximum number of simultaneous appointments->across then down.

The issue would be how to get the person group as the outermost group while still showing all possible datetimes for each diary. You could instead use a parameter to print the diary for each specific person.

-LB