Line chart

Frank · Post by **Frank** » Wed Apr 08, 2009 10:00 am

Hi Forum,

I have a line chart in my report and I want to set the x-axis to a fixed amount of labels. Starting from the first row recieved from my datasource (Argument Data Column), till my last one. In between those rows in don't know the amount of records. The setting 'Show edge values' has no impact, while I would expect to see the first and last value.
Also with the setting step I don't recieve the result I need, because this setting depends on the amount of records receiving from the datasource. How can I achieve the desired result???

Next Issue is how can I make the 'Title' multilanguage of the graph???

Last question, I have 1 default report with trending. But the amount of trendings is different for each application. Meaning the result of the datasource I receive as input for the charts has no fixed amount of columns. I.e. the Table has the next columns: LogTime (DATETIME), TEMP1 (REAL), TEMP2 (REAL) and TEMP3 (REAL). Depending on the application TEMP3 is present or not. Can I somehow configure the chart that it will not show the the missing trend.
If the column is not present the series in the chart displays nothing, but the label of the series remains.
Is there some functionality like EXISTS???

Kind regards,
Frank

Post by **Jan** » Thu Apr 09, 2009 3:54 pm

Hello Frank,

I have a line chart in my report and I want to set the x-axis to a fixed amount of labels. Starting from the first row recieved from my datasource (Argument Data Column), till my last one. In between those rows in don't know the amount of records. The setting 'Show edge values' has no impact, while I would expect to see the first and last value.
Also with the setting step I don't recieve the result I need, because this setting depends on the amount of records receiving from the datasource. How can I achieve the desired result???

This is not possible. This is dynamic value. Amount of labels depend from amount of data.

Next Issue is how can I make the 'Title' multilanguage of the graph???

At this moment only with help of script in report.

Last question, I have 1 default report with trending. But the amount of trendings is different for each application. Meaning the result of the datasource I receive as input for the charts has no fixed amount of columns. I.e. the Table has the next columns: LogTime (DATETIME), TEMP1 (REAL), TEMP2 (REAL) and TEMP3 (REAL). Depending on the application TEMP3 is present or not. Can I somehow configure the chart that it will not show the the missing trend.
If the column is not present the series in the chart displays nothing, but the label of the series remains.
Is there some functionality like EXISTS???

You can use following code in BeforePrintEvent:

Code: Select all

if (condition)
{
  Chart1.Series.RemoveAt(0);
}

Thank you.

Frank · Post by **Frank** » Fri Apr 10, 2009 4:14 am

Hi Jan,

Thanx for the response, can you explain to me how to make a script in a report? Maby by some easy example.
And where can I find the pront event?

Post by **Jan** » Fri Apr 10, 2009 9:23 am

Hello Frank,

Please check attached image.

Thank you.