Column header group date

[rwolburg]

how can i make that the column respect the space of the header column?

The detail of tuesday is so big that the column is finished so it has to start in other column but not in the same place, just in the line of the titles. One group is the date and de detail are the classes and the footer has the option print at bottom of pate to make a new column each time the date changes

1 Monday 1 Tuesday 2 14:00 Math Wednesday 3
2 14:50 Prf Rick
3 08:00 Spanish 08:00 Bio 08:00 ESP 1
4 08:50 Prf John 08:50 prf x 08:50 prf a
5 15:00 ESP 1
6 09:00 Bio 09:00 esp 1 15:50
7 09:50 prf a 09:50 prf a

Thanks in advanced

 

[lbass]

So you have formatted the date with "format with multiple columns".

What exactly do you want to happen when there is too much data? All you can really do here is reduce line height (maybe using a smaller font) or adjust the page margins and/or the page header and page footer heights.

You could also see if a crosstab meets your needs, where you put the dayofweek across the top and the time as the row field, with maximum of class as the summary field (assuming there are not two classes at the same time).

-LB

 

[rwolburg]

i want that the class on Tuesday 14:00 Math starts printing just behind the line of the titles "Weekofday, day" there only need just 2 blank spaces. The number of events on a day are impredecible so, we could have 1 or 20.
the dataset is
Datetime, hour, body
14 11 2011 11:00 12:00 " Math............
14 11 2011 12:10 12:30 " break"

and i have grouping in date and choose multiple columns for the detail which are the other two columns

is there any way to know if crystal is printing in the second column of the day, knowing this i could try printing some blank rows each time crystal starts another column of the same day

 

[lbass]

You should check format with multiple columns->layout->format groups with multiple columns. You also need to have printer at bottom of page set on the group footer.

Then insert a running total {#cntwingrp} that counts your class field, evaluates for each record and resets on change of group (date).

Make sure that each page has the same height (use new page after on the report header or suppress it). Add {#cntwingrp} to the detail section and observe the number of the last row of the first column. Let's say it is 58. Then create a formula like this:

if remainder({#cntwingrp},59)=0 then//59=58+1
chr(13)+{table.class} else
{table.class}

Add this formula to the detail section instead of the table.class field. Be sure to format this formula to "can grow".

Then remove the {#cntwingrp}. You might have to adjust the line height if adding the formula changed the number of rows that fit on the page.

Note that if there can ever be more than two columns in a group, then the formula has to be more complex, since the can grow will cause the row count to be one less in each additional column.

-LB

 

[rwolburg]

Thankyou very much... i start with what you gave me.. but i also use len(field) cause each row could change a lot... and i count the characters insted of records.

Thankyou again