Best approach suggestions?

rbuser

I have a client using the End User designer (with rap version 9.02)
who wants to produce a report like this:

1) Single dataview with a date, a time range and a type.
2) The report is to have headings of each hour (00:00 to 23:00) with
rows being the dates.
3) For each row for a single date:
- Print a block containing the time range e.g. 01:17-02:53
- Color the block depending on the type
- Don't overlap the blocks. If the items times overlap move the
second one for the period to a new line.
- Only use as many lines as needed. In other words if there is an
overlap contained completely in hour 4 and in hour 10 there should be
two lines not three.

What would be the best approach?

Many thanks.
Rick Matthews
FDM Software Ltd.

nicocizik

Hi Rick,

This should be possible however it will require an amount of pre-processing
of your data in order to get the correct output.

2. You could manually place each hour as a static TppLabel inside the page
header band or title band of the report.

3. One option would be to manually create rectangles and size and position
them at runtime to take up a slot of time based on the value in the data
record. Color would have to be controled in code as well.

You will need to find a way to preprocess your data so that if no conflict
occurs on the same date, the same row (in your dataset) will be used to
display multiple time ranges.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com