Connecting to Databases
Our sample projects and report templates can help you learn the basics of working with our products.This example is outdated, you can check out the many other new examples in this category.This example shows how to connect to databases from designer. First of all, load scripts for viewer:
Next, connect data adapters:
Finally, create report designer:
In the screenshot below you can see the result of the sample code:
<script src="/Scripts/stimulsoft.reports.js" type="text/javascript"></script>
<script src="/Scripts/stimulsoft.viewer.js" type="text/javascript"></script>
<script src="/Scripts/stimulsoft.designer.js" type="text/javascript"></script>
<script src="/Scripts/stimulsoft.blockly.js" type="text/javascript"></script>Next, connect data adapters:
<script type="text/javascript">
function onLoad() {
StiOptions.WebServer.encryptData = false;
StiOptions.WebServer.url = "/DataAdapters";
...Finally, create report designer:
...
var options = new Stimulsoft.Designer.StiDesignerOptions();
options.appearance.fullScreenMode = true;
var designer = new Stimulsoft.Designer.StiDesigner(options, "StiDesigner", false);
designer.renderHtml("content");
designer.report = new Stimulsoft.Report.StiReport();
}
</script>In the screenshot below you can see the result of the sample code: