i have many lists in sharepoint that gather information from another lists by lookup fields.

we want to make a report by kendo pivot grid.

we have more that 30 reports that connected to lists and show data in kendo grid. but this article has a complex things about kendo pivot grid.

first question is i cant find this dll : http://demos.telerik.com/olap/msmdpump.dll

and don't know how can i host this dll in my IIS or sharepoint and i dont know what is the best way to use it safe?

next problem is that my datasource is not in SSAS - sql server and i have lists.

dataSource: {
                    type: "xmla", //define the type
                    columns: [{ name: "[Date].[Calendar]" }], //specify a dimesion on columns
                    rows: [{ name: "[Product].[Category]" }], //specify a dimesion on rows
                    measures: ["[Measures].[Internet Sales Amount]"], //specify a measure to display
                    transport: {
                        connection: {
                            catalog: "Adventure Works DW 2008R2", //specify the name of the catalog
                            cube: "Adventure Works" //specify the name of the cube

in other try i can make synced sql server table in my DBs and i have tools that return json from sql but cant make pivot simple sample by this component.

we have many javascript componrents like amcharts and Highcharts that use them and create many reports very easy in my SharePoint portal.

is there any online sample that connected to SharePoint? one clear sample better that 10 articles. :)


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.