Custom SQL Data Survery Analytics
Author: fkim
Creating SSRS reports with MDX quieres – YouTube
This is to create SSR based on MDX query
JasonP Implementaion on MVC Controller
public ActionResult UsageJasonP()
{
db.Configuration.LazyLoadingEnabled = false;
db.Configuration.ProxyCreationEnabled = false;
var waterusages = db.WaterUsages;
//return Json(waterusages, JsonRequestBehavior.AllowGet);
return new JsonpResult(waterusages,”receive”);
}
var url = “http://localhost:15214/water/UsageJasonP?callback=?”;
$.ajax({
url: url, dataType: “jsonp”, jsonpCallback: “receive”, callback: “receive”,
success: function (data, status) {
//mySurvey.closePopup();
alert(“Success”);
console.log(data);
},
error: function (xOptions, textStatus) {
alert(“fails”);
}
});
Defining a Dimension
Source: Defining a Dimension
Enesys RS Data Extension – KB and Samples – reporting_on_survey
ASP Net Core / Docker
sql – SSRS calculate percentage of column based on row total – Stack Overflow
Calculate percentage of total columns based on total column in SSRS Matrix – Stack Overflow
sql – Reporting Services Chart – Custom Axis Label – Stack Overflow
Drill Down Chart Report in SSRS
Drill Down Chart Report in SSRS,Drill Down Chart Report,SSRS,Visual Studio 2010,Visual studio 2008,Sql Server 2012,Sql Server 2008,SSRS,Reporting Services
Source: Drill Down Chart Report in SSRS