CGDevTools Forum

Hi

I use some setting for JQPivot in design time.But don't apply anything.
and then
I use below code for setting

Code: Select all

        IWCGJQPivot.JQPivotUIOptions.AutoSize:= True;
        IWCGJQPivot.JQPivotType:= jqptPivotUI;
        IWCGJQPivot.FileName:= 'data/MyPivot.json';
        IWCGJQPivot.JQPivotUIOptions.Rows.Add('F1');
        IWCGJQPivot.JQPivotUIOptions.Cols.Add('F2');
        IWCGJQPivot.JQPivotUIOptions.Vals.Add('F3');
        IWCGJQPivot.JQPivotUIOptions.RendererName := jqprHeatmap;
        IWCGJQPivot.JQPivotUIOptions.AggregatorName := jqpaIntSum;


But don't apply Below Code.

Code: Select all

        IWCGJQPivot.JQPivotUIOptions.Vals.Add('F3');
        IWCGJQPivot.JQPivotUIOptions.RendererName := jqprHeatmap;
        IWCGJQPivot.JQPivotUIOptions.AggregatorName := jqpaIntSum;


What I do for apply change?

Best Regards.

Hi ariopax,

Can you send us the simple testcase please? T.I.A
P.S: And don't forget the json file

Best Regards.

Hi

This is my testcase.
Please create Data folder in wwwroot for json file.
Please copy pivot.fa.js to wwwroot\jq\pivottable for setting Farsi(Persian Language).
And I have a question.
How to set my sort for cols?
For example i want set cols from One To Six.


Best Regards.

hi Ario

Open you'r file pivot.fa.js and then remove frFmt = nf({
thousandsSep: " ",
decimalSep: ","
});
Best Regards.

Hi aftabgardan2006


My Problem Solved.Thanks.
And in this file pivot.fa.js ,on aggregators function ,i put sum aggregator in first line "مجموع": tpl.sum(frFmt),then IWCGJQPivot.JQPivotUIOptions.AggregatorName := jqpaIntSum; command worked.



Best Regards.

Hi ariopax,

It was a issue with jquery plugin and fixed in beta build (which I will upload in few hours).

Thanks.

Best Regards.