Expected value for Format column in GanttResources?

[Diego]

Hello,

It says on the documentation that "Another optional column for the Resources Table is Format. This column define the format of the assignment Units and its default value is percentage("p0").".

I have created this column as an nchar(10) (just like the "Color" column) in the GanttResources table and I've tried n0, p0 and c0 as values for my resources but every time the unit displayed is %.

Is there a list of expected values for this column or does it have to be enabled somewhere I'm missing? The documentation about RadGantt doesn't mention this column anywhere else nor do the examples provided use this table in any sort of way.

Thank you for your help!

[Peter Milchev]

Hello Diego,

The format is set to the "Format" property of the resource. Here is how it would look like when the resource format is set: 



In the SQL data table with the resource, the type of the Format column should be nvarchar instead of nchar. 

Also, if you add the resources programmatically, you can use the following syntax.

// add resources programmatically
 RadGantt1.Resources.Add(new Telerik.Web.UI.Gantt.Resource()
{
    ID = 1,
    Color = Color.Red,
    Text = "Thomas Hardy",
    Format = "n4"
});
RadGantt1.Resources.Add(new Telerik.Web.UI.Gantt.Resource()
{
    ID = 2,
    Color = Color.GreenYellow,
    Text = "Elizabeth Lincoln",
    Format = "p3"
});

Or if you bind the resources from the data source (this example is showing the XML provider scenario): 

<Resources>
  <Resource>
    <ID>1</ID>
    <Text>Thomas Hardy</Text>
    <Color>#f44336</Color>
    <Format>n4</Format>
  </Resource>
  <Resource>
    <ID>2</ID>
    <Text>Elizabeth Lincoln</Text>
    <Color>#880e4f</Color>
    <Format>p3</Format>
  </Resource>
</Resources>

The Resources that the Gantt uses are implementing the IResource and  interfaces: 

namespace Telerik.Web.UI.Gantt
{
    public interface IResourceBase
    {
        object ID { get; set; }
        string Text { get; set; }
        string Format { get; set; }
    }

    public interface IResource : IResourceBase, IMarkableStateManager
    {
        Color Color { get; set; }
        IOrderedDictionary GetData();
        void LoadFromDictionary(IDictionary values);
    }
}

For your convenience, I have attached a sample project implementing the suggested approach.

Regards,
Peter Milchev
Progress Telerik