Creating reports and dashboards | Stimulsoft community forum

Code: Select all

ReferenceError: StiDatePickerShow is not defined

StiDatePickerShow(this, "yyyy/mm/dd");

Code: Select all

<Sti:StiWebViewer ID="viewer" runat="server" Visible="false" />

Code: Select all

public void LoadReport(Report model)
{
	var report = new StiReport();
	report.Load(model.Path);

	if (IsValidReport(report.GetComponents()))
	{
		string filter = this.FilterValue;

		foreach (StiSqlDatabase database in report.Dictionary.Databases)
		{
			database.ConnectionString = ConfigurationManager.ConnectionStrings["Connstr"].ConnectionString;
		}

		
		if (!string.IsNullOrEmpty(filter))
		{
			foreach (StiDataSource dataSource in report.Dictionary.DataSources)
			{
				string query = ((StiSqlSource) dataSource).SqlCommand;

				((StiSqlSource) dataSource).SqlCommand = query.Replace("('%wc%' = '%wc%')",
																	   string.Format("({0} IN ({1}))",
																					 model.KeyWord,
																					 filter));
			}
		}

		this.viewer.Report = report;
		this.viewer.ProcessReport();
		this.viewer.Visible = true;
	}
	else
	{
		this.InvalidReportErrorVisible = true;
	}
}

private static bool IsValidReport(StiComponentsCollection components)
{
	bool isValidReport = true;

	var invalidControlTypes = new List<Type>
								  {
									  typeof (StiGroupBoxControl),
									  typeof (StiGridControl),
									  typeof (StiPictureBoxControl),
									  typeof (StiCheckedListBoxControl),
									  typeof (StiLookUpBoxControl),
									  typeof (StiNumericUpDownControl),
									  typeof (StiListViewControl),
									  typeof (StiTreeViewControl)
								  };

	foreach (StiComponent component in components)
	{
		Type type = component.GetType();

		foreach (Type invalidType in invalidControlTypes)
		{
			if (type == invalidType)
			{
				isValidReport = false;
			}
		}
	}

	return isValidReport;
}