Need a diagonal line 1

[Montana751]

Crystal XI - SQL

I need to replicate an official form, which has a diagonal line in the detail section; where some data shows to the Top Right before the line and other data displays Bottom Right under the line.

The data is easy, I can't figure out how to draw the diagonal, just straight.

I was trying to use an object, but thats not working out so good.

 

[lbass]

I was able to create a diagonal line by creating two formulas:

//{@onchgof}:
if {table.name}[1] = "P" then 0 else 1 //limit to two values

//{@showval}:
if {@onchgof} = 0 then 0 else 100

Then insert a chart->line->add {@onchgof} as the on change of field, and {@showval} as the show value field. Check "Don't summarize."

Then select each element of the chart that you don't want displayed and format it to be transparent. After doing this, you will have only the diagonal line. Note that to eliminate the 0 y axis, you need to select the zero line and uncheck "show zero value".

-LB