when I open my ReportDesigner.aspx I get
To view this page ensure that Adobe Flash Player version 11.1 or greater is installed.
The dll's in the bin all say 2016.1
What am I doing wrong?
here is my code
in my webconfig.
Code: Select all
<pages clientIDMode="AutoID">
<controls>
<add tagPrefix="stimDesign" namespace="Stimulsoft.Report.Web" assembly="Stimulsoft.Report.WebDesign"/>
<add tagPrefix="stimWeb" namespace="Stimulsoft.Report.Web" assembly="Stimulsoft.Report.Web"/>
</controls>
</pages>.aspx file
Code: Select all
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ReportDesign.aspx.cs" Inherits="ReportDesign" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<StimDesign:StiWebDesigner ID="StiWebDesigner1" SaveMode="Hidden" OnSaveReportAs="StiWebDesigner1_SaveReportAs" OnSaveReport="StiWebDesigner1_SaveReport" runat="server" />
</form>
</body>
</html>
Code: Select all
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Web.Configuration;
using Stimulsoft.Report.Web;
public partial class ReportDesign : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string ReportString = "";
// Stimulsoft.Report.StiSelectGuiHelper.IsRibbonGui = false;
//Stimulsoft.Report.StiOptions.Designer.ShowSelectTypeOfGuiOption = true;
Stimulsoft.Report.StiReport report = new Stimulsoft.Report.StiReport();
string ReportGuid = Request["rg"];
if (String.IsNullOrEmpty(ReportGuid))
{
//its empty so the user wants to create a new report
ReportGuid = "Documents_Template";
}
StiWebDesignerOptions.Menu.SaveAs = false;
StiWebDesignerOptions.Menu.NewPage = false;
StiWebDesignerOptions.Menu.NewEnabled = false;
//Load your Report String from Database
string sql = "select ReportXML from reports where ReportGuid = '" + ReportGuid + "'";
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["ReportsConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = sql;
using (con)
{
con.Open();
cmd.ExecuteNonQuery();
ReportString = cmd.ExecuteScalar().ToString();
}
if (Page != null)
{
string keyValue = Page.Request.QueryString.Get("stimulsoft_webdesigner");
if (!IsPostBack && keyValue == null)
{
if (!String.IsNullOrEmpty(ReportGuid))
{
report.LoadFromString(ReportString.ToString());
StiWebDesigner1.Design(report);
}else
{
StiWebDesigner1.Design();
}
}
}
}
protected void StiWebDesigner1_SaveReport(object sender, Stimulsoft.Report.Web.StiWebDesigner.StiSaveReportEventArgs e)
{
Stimulsoft.Report.StiReport report = e.Report;
string ra = report.MetaTags["ReportGuid"].Tag;
string reportString = report.SaveToString().Replace("\"","\"").Replace("'","''");
string sql = "Update reports set ReportXML = '" + reportString + "' where ReportGuid = '" + ra + "'";
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["ReportsConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = sql;
using (con)
{
con.Open();
cmd.ExecuteNonQuery();
}
con.Close();
}
protected void StiWebDesigner1_SaveReportAs(object sender, Stimulsoft.Report.Web.StiWebDesigner.StiSaveReportEventArgs e)
{
Stimulsoft.Report.StiReport report = e.Report;
//get the old report guid
string ra = report.MetaTags["ReportGuid"].Tag;
//get a new report guid
string NewReportGuid = Guid.NewGuid().ToString();
//replace the meta tag report guid with the new report guid
report.MetaTags["ReportGuid"] = new Stimulsoft.Report.StiMetaTag("ReportGuid", NewReportGuid);
//report.MetaTags.Remove(report.MetaTags["ReportGuid"]);
// Stimulsoft.Report.StiMetaTag tag = report.MetaTags["ReportGuid"];
//report.MetaTags.Remove(tag); // Clear specified tag
//convert report to string xml
string reportString = report.SaveToString().Replace("\"", "\"").Replace("'", "''");
string rn = report.ReportName;
reportString = reportString.Replace(ra, NewReportGuid);
reportString = reportString.Replace(rn, "Copy of " + rn);
string sql = "Insert into reports (AppID,ReportGUID,ReportTitle,ReportXML,Template) " +
" Values ('1','" + NewReportGuid + "','" + "Copy of " + rn + "','" + reportString + "',0)";
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["ReportsConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = sql;
using (con)
{
con.Open();
cmd.ExecuteNonQuery();
}
con.Close();
}
}