I've been trying to use the charting on print time formulas pdf file from Crystal Decisions for Crystal Report 9.
I am running into one problem.
The chart is blank.
Formulas are as follows:
@SubShowValue //in the sub report
ToNumber(Split({?Pm-@ShowValue}, "^"
[RecordNumber])
@ShowValue
stringvar strShowValue;
strShowValue := strShowValue + totext({@displaystest}) + "^";
@OnChangeOf
whileprintingrecords;
stringvar strOnChangeOf;
strOnChangeOf := strOnChangeOf + {SensorData.SensorName} + "^"
the parameters that are being passed to the subreport are:
@ShowValue
14.00^32,793.00^14,476.00^21,871.00^4,658.00^4,955.00^4,523.00^21,923.00^1,095.00^1,095.00^
@OnChangeOf
Bloomberg^Choke^Outside^Prod_Cert^Prod_CA_Web^Prod_Net^Prod_Tran^Prod_Web^scanner_1^scanner_1
On the main report:
GROUP HEADER:
@clearstest
whileprintingrecords;
shared NumberVar st;
st := 0
DETAILS:
@newstest
whileprintingrecords;
shared NumberVar st;
if {SensorData.AlertCount} <= 0 then
st := st + 1
else
st := st + {SensorData.AlertCount};
st
GROUP FOOTER A:
{sensorname.sensordata}
@displaystest
whileprintingrecords;
shared NumberVar st;
shared NumberVar gt;
gt := gt + st;
st
GROUP FOOTER B:
@OnChangeOf
@ShowValue
REPORT FOOTER A:
@displaygtest
whileprintingrecords;
shared numbervar gt;
gt
REPORT FOOTER B:
ChartSub // subreport with chart
On the sub report:
REPORT FOOTER:
CHART // Sensordata.SensorName - A for the On Change Of
// @SubShowValue for the Show Value
The record selection for the sub report is as follows:
{SensorData.SensorName} in split({?Pm-@OnChangeOf},"^"![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I am running into one problem.
The chart is blank.
Formulas are as follows:
@SubShowValue //in the sub report
ToNumber(Split({?Pm-@ShowValue}, "^"
@ShowValue
stringvar strShowValue;
strShowValue := strShowValue + totext({@displaystest}) + "^";
@OnChangeOf
whileprintingrecords;
stringvar strOnChangeOf;
strOnChangeOf := strOnChangeOf + {SensorData.SensorName} + "^"
the parameters that are being passed to the subreport are:
@ShowValue
14.00^32,793.00^14,476.00^21,871.00^4,658.00^4,955.00^4,523.00^21,923.00^1,095.00^1,095.00^
@OnChangeOf
Bloomberg^Choke^Outside^Prod_Cert^Prod_CA_Web^Prod_Net^Prod_Tran^Prod_Web^scanner_1^scanner_1
On the main report:
GROUP HEADER:
@clearstest
whileprintingrecords;
shared NumberVar st;
st := 0
DETAILS:
@newstest
whileprintingrecords;
shared NumberVar st;
if {SensorData.AlertCount} <= 0 then
st := st + 1
else
st := st + {SensorData.AlertCount};
st
GROUP FOOTER A:
{sensorname.sensordata}
@displaystest
whileprintingrecords;
shared NumberVar st;
shared NumberVar gt;
gt := gt + st;
st
GROUP FOOTER B:
@OnChangeOf
@ShowValue
REPORT FOOTER A:
@displaygtest
whileprintingrecords;
shared numbervar gt;
gt
REPORT FOOTER B:
ChartSub // subreport with chart
On the sub report:
REPORT FOOTER:
CHART // Sensordata.SensorName - A for the On Change Of
// @SubShowValue for the Show Value
The record selection for the sub report is as follows:
{SensorData.SensorName} in split({?Pm-@OnChangeOf},"^"