I need to create Chart which should show data based on the following table structure and requirements.
Table name - FSchedules. Table Fields - Sched_ID, Completion_Date, Projected_Date.
Chart requirements -
1. X-Axis labels should show Sched_ID and corresponding Projected_Date below each Sched_ID
2. Y-Axis (Data Axis) should have 1 (one) label in the middle for the first Completion_Date.
3. Chart should show 2 lines -
A. 1st line (blue line) for Completion_Date
B. 2nd line (red line) for Projected_Date
4. Y-Axis should be Descending Axis.
5. I should not show Data Labels for both lines, BUT I should show labels along red line with numbers equal to the
difference between Projected_Date and Completion_Date.
My questions are -
1. Can I make such chart using Crystal Reports? If 'Yes', should I use Crystal Design or use RDC GraphObject in runtime? If 'No', what tool would you recommend?
2. How to make 2 rows of labels along X-Axis (see requirement #1 above)?
3. Is there a way to display Dates on Data Axis (Y-Axis)? I was not able to display Dates, so I made formulas to convert Dates to strings in Crystal.
4. How to make Descending Y-Axis using RDC GraphObject in runtime? Note - I can make Descending Y-Axis in Crystal design - right click on chart, select Format Chart, Grid, General tab, check 'Make this a Descending Axis'. This works OK, but this is done in Crystal design, not in runtime.
5. How can I show labels along red line with numbers that are calculated as difference between dates (see requirement #5 above)?
Thanks.
Seva Vaysband
Table name - FSchedules. Table Fields - Sched_ID, Completion_Date, Projected_Date.
Chart requirements -
1. X-Axis labels should show Sched_ID and corresponding Projected_Date below each Sched_ID
2. Y-Axis (Data Axis) should have 1 (one) label in the middle for the first Completion_Date.
3. Chart should show 2 lines -
A. 1st line (blue line) for Completion_Date
B. 2nd line (red line) for Projected_Date
4. Y-Axis should be Descending Axis.
5. I should not show Data Labels for both lines, BUT I should show labels along red line with numbers equal to the
difference between Projected_Date and Completion_Date.
My questions are -
1. Can I make such chart using Crystal Reports? If 'Yes', should I use Crystal Design or use RDC GraphObject in runtime? If 'No', what tool would you recommend?
2. How to make 2 rows of labels along X-Axis (see requirement #1 above)?
3. Is there a way to display Dates on Data Axis (Y-Axis)? I was not able to display Dates, so I made formulas to convert Dates to strings in Crystal.
4. How to make Descending Y-Axis using RDC GraphObject in runtime? Note - I can make Descending Y-Axis in Crystal design - right click on chart, select Format Chart, Grid, General tab, check 'Make this a Descending Axis'. This works OK, but this is done in Crystal design, not in runtime.
5. How can I show labels along red line with numbers that are calculated as difference between dates (see requirement #5 above)?
Thanks.
Seva Vaysband