Cant get Pivotgrid to work

[Konstantinos Oikonomou]

Hello, 

my name is K.Oikonomou and i have recently downloaded your MVC and JS controls. What i am intrested in is pivotgrid bound with OLAP Cube data.

I am trying to create my first pivotgrid in both MVC and Javascript and i can get none to work.

I have followed the instructions from here: 
http://help.syncfusion.com/ug/js/index.html#!Documents/createyourfirstpivotgridinmvc.htm
and here:
http://help.syncfusion.com/ug/js/index.html#!Documents/createyourfirstpivotgridinjavascript.htm

MVC problem: I run the project and there is a <div> element added for the pivotgrid but there is nothing in it:
<div id="PivotGrid1" data-role="ejpivotgrid" data-ej-url="/wcf/PivotGridService.svc" data-ej-servicemethodsettings-drilldown="DrillPivotGrid"></div>
No loaders or spinners are displayed on the page, just a completely white html page. And there are no errors in the console.

JS problem: I run the project a spinner appears momentarily and then disappears. Like before there a <div> element added to the page:

<div id="PivotGrid" style="height: 350px; width: 100%; overflow: auto" class="e-pivotgrid e-js e-waitingpopup" tabindex=""></div>

but there is nothing in it. In that case however there is an error on the console.

I have attached both projects in order to help you help me.

SyncFusionPivotFirst ---> MVC pivotgrid
WebApplication2  ------> Javascript pivotgrid

P.S. i am using: VS 2013, syncfusion v13.1.0.21 and ASP.NET MVC 5

Attachment: Projects_769a8eb6.rar

[Alagarsamy D]

Hi Oikonomou,

Thank you for using Syncfusion products.

Query	Answer
JS problem: I run the project a spinner appears momentarily and then disappears. Like before there a <div> element added to the page:	We have removed the “using Webapplication2.wcf” from namespaces and ran the sample. Its working fine now and we have attached the modified sample in the below link. Sample Link: http://www.syncfusion.com/downloads/support/forum/119290/ze/WebApplication2219820262
MVC problem: I run the project and there is a <div> element added for the pivotgrid but there is nothing in it:	We have checked the MVC sample provided by you and the following namespaces are commented in web.config file. <namespaces>         <add namespace="System.Web.Helpers" />         <add namespace="System.Web.Mvc" />         <add namespace="System.Web.Mvc.Ajax" />         <add namespace="System.Web.Mvc.Html" />         <add namespace="System.Web.Optimization" />         <add namespace="System.Web.Routing" />         <add namespace="System.Web.WebPages" />         <add namespace="Syncfusion.MVC.EJ"/>         <add namespace="Syncfusion.JavaScript"/>         <add namespace="Syncfusion.JavaScript.DataVisualization"/> </namespaces> We uncommented the same and ran the sample, it working fine. Please find the attached modified sample in the below link. Sample Link: http://www.syncfusion.com/downloads/support/forum/119290/ze/SyncFusionPivotFirst379612637

Please let us know if you have any concerns.

Thanks,
Alagarsamy D.

[Konstantinos Oikonomou]

JS problem: Your example worked. So i guess i have to have PivotGridService and IPivotGridService at the same namespace? That would be something that it would be worth noting in your guide here: http://help.syncfusion.com/ug/js/index.html#!Documents/createyourfirstpivotgridinjavascript.htm

MVC problem: Your example still doesnt work for me (maybe you sended the wrong file?). when i run the project i get the following error in the console:
POST http://localhost:21712/wcf/PivotGridService.svc/InitializeGrid 404 (Not Found)

Seems like the service is expected to be named PivotGridService.svc but in the example posted it is named PivotGridService.svc.svc. 
Renaming the files like PivotGridService.svc seems to solve that problem since it stops appearing in the console. BUT, then we return to the previous problem of an empty div on the DOM and no error in the console...

[Alagarsamy D]

Hi Konstantinos,

Thank you for using Syncfusion products.

We would like to inform you that the provided sample is working fine at our end and we have attached a video for your reference in the below link. We suspect that the problem was extra “.svc” contain in “PivotGridService.svc” file. So remove the “.svc” and run the sample.

Video Link:
http://www.syncfusion.com/downloads/support/forum/119290/ze/MVC_PivotGrid-1423454998

Please let us know if you have any concerns.

Thanks,
Alagarsamy D.