Can objects be sized/positioned by formula

[vb6novice]

In CR XI, I plan to mimic the MS Project Gantt chart using a horizontal bar (text box perhaps) in the detail. The position and width of the horizontal bar will need to change with each record. Is that possible in CR?

The record set has 1 record for each person who will work on a job - there will be many jobs in the report. The fields included are:
- Job Number
- Worker's name
- Estimated hours
- Job start date

Records will be grouped by Worker's name.

For each worker, I want the detail to be a horizontal bar to represent the work period, starting from an x position which represents the job's start date and extending to the right an amount proportional to the number of days the job will take to complete (which will be a calculaton of Estimated hours divided by a fixed working hours per day).

The report will have parameters to allow users to specify a date range. The width of each horizontal bar will depend on the days needed to complete the job divided by days in date range.

Thanks for any help.

 

[synapsevampire]

Nothing can really be dynamically changed horizontally within Crystal.

There are cheats, however they might be unappetizing/cumbersome.

One would be to estimate the number of characters needed to fill the text object with a given character, and appropriately padding it at the beginning with spaces. Note that you migth receive a different look depending upon the printer and font used across systems.

I would opt for having X number of days as seperate formulas touching each other and then conditionally filling each depending upon the days. A pain to initially set up, but it should provide the best look and feel across printers.

There are gantt charts available within Crystal.

-k

 

[vb6novice]

k,

I had already thought of your suggestion (to fill the box with a number of characters appropriate to the required length of the bar) but was hoping for a more 'elegant' solution.

The Gantt charts within CR don't behave like I want them to(or perhaps I just don't know how to make them behave the way I want them to).

I'll consider trying your suggestion.

Thanks.