Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Columnname for charts, used in the legend

Hello,

Hopefully someone can help me. I'm using the charts and I'm satisfied with the results.

I start from a controller that gets is data from a SQL-server stored procedure.

The chart I'm using is a area type, with data from 12 months. I also give a YTD and MAT figures.

But ... the legend will always show the fieldname from the column where the date (pivot1-val1-sum) is used.

Question : how can we change that name ? Of do we have to adjust the SQL-query eacht time, and update the controller ?

Thank you and best regards,

Marc
1 person has
this question
+1
Reply
  • Hello,

    I found a quick-solution, but only temporay ...

    By adapting HandleServiceRequest in ApplicationServices.cs it was solved (checking Controller name and the Replacing text in the Object result.

    But after generating & publishing it is lost !

    Is there any solution to do that replacing in ApplicationServicesOverride.cs ?

    Thank you very much,
    Marc
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited

  • Hello,

    I traced the problem with Fiddler and saw that the data from the controller are merged into 9 pivots for the 9 charts (see below).

    COT doesn't use ColumnFieldNames, but the names are added in the Data as a first row.

    This conversion uses Field.Name instead of Field.Label, which could solve this problem. Now the 'columnname' of my Sql server is shown.

    Could I change that with an 'overide' or business rule ?

    Thank you very much,

    Marc

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited