How to display the details horizontal as opposed to vertical

[haneen97]

Hi,
The user requested to se the appointments in a calendar format. She wants to see the department on the top and the rooms listed across the screen. The department and the rooms are groups in the detail sections. They come out like this:

Department 1
Room 1
Appt 1
Appt 2
Room 2
Appt 3
Appt 4
Room 3
Appt 5
Appt 6
Department 2
Room 4
Appt 7
Appt 8
Room 5
Appt 9
Appt 10
Room 6
Appt 11
Appt 12

She wants it like this:

Department 1
Room 1 Room 2 Room 3
Appt1 Appt 3 Appt5
Appt2 Appt4 Appt 6

Department 2
Room 4 Room 5 Room 6
Appt7 Appt 9 Appt11
Appt8 Appt10 Appt 12


Is there a way that we can get the details to display horizontal as opposed to vertical?

Thanks a lot


Mo

 

[lbass]

You might try a crosstab placed in the department group header or footer. Use Room # as the column field, and maybe {table.date} as the row field. Then add NthSmallest, N = 1, of {table.appt} as the summary field. Add this field repeatedly, changing the N up to the maximum number of appointments expected per room.

Another approach would be to go to the section expert->details->check format with multiple columns->layout and set the width and gap between details, choose "Down then across" and also check "Format groups with multiple columns." If the groups have different numbers of appointments, it is difficult to get the group headers aligned at the top of each column, however.

-LB

 

[haneen97]

Hi,
The first optino seems to be the best. But, I can't get the details to display. All my options are summary fields which calcualte min,max, count etc...

How can I add my own detail fields from the table?

I am using Crytsal 10 by the way.

Thanks a lot.

Mo

 

[lbass]

What is the datatype of your summary field? You should have NthSmallest as an option. Try adding your detail field multiple times and each time choose NthSmallest, incrementing the value of N by 1 each time.

-LB

 

[haneen97]

I get it now, It looks great. Thanks a lot for your help.

Mo

 

[haneen97]

Hi it is me again,
One more Question about the same format. Can I get a summarized field to wrap?

Thaks

Mo

 

[lbass]

While in preview or design mode, you can grab the boundaries of the summary field and manually resize it--make it narrower and taller, if you like--but I don't believe there is a way to automatically wrap it when it doesn't fit.

You can adjust the amount of space used within the cell by unchecking "show cell margins" while in the format crosstab->customize style screen, although this doesn't look as nice. You can also eliminate the grid if you wish.

-LB