public Form1()
{
InitializeComponent();
Dashboard dashboard = new Dashboard();
dashboard.LoadFromXml(@"..\..\Data\Dashboard.xml");
DashboardSqlDataSource dataSource = (DashboardSqlDataSource)dashboard.DataSources[0];
GridDashboardItem grid = (GridDashboardItem)dashboard.Items[0];
// Create a new dashboard parameter.
StaticListLookUpSettings settings = new StaticListLookUpSettings();
settings.Values = new string[] { "0.01", "0.05", "0.1" };
DashboardParameter discountValue = new DashboardParameter("discountValue",
typeof(double), 0.05, "Select discount:", true, settings);
dashboard.Parameters.Add(discountValue);
// Create a new calculated field and pass the created dashboard parameter
// to a calculated field expression.
CalculatedField isGreater = new CalculatedField();
isGreater.DataMember = "SalesPerson";
isGreater.Name = "IsGreater";
isGreater.Expression = "ToStr(Iif(Avg([Discount]) >= [Parameters.discountValue], 'TRUE', 'FALSE'))";
dataSource.CalculatedFields.Add(isGreater);
grid.Columns.Add(new GridMeasureColumn(new Measure("IsGreater")));
dashboardViewer1.Dashboard = dashboard;
}
public Form1()
{
InitializeComponent();
Dashboard dashboard = new Dashboard();
dashboard.LoadFromXml(@"..\..\Data\Dashboard.xml");
// Creates a new dashboard parameter.
StaticListLookUpSettings staticSettings = new StaticListLookUpSettings();
staticSettings.Values = new string[] { "1994", "1995", "1996" };
DashboardParameter yearParameter = new DashboardParameter("yearParameter",
typeof(string), "1995", "Select year:", true, staticSettings);
dashboard.Parameters.Add(yearParameter);
DashboardSqlDataSource dataSource = (DashboardSqlDataSource)dashboard.DataSources[0];
CustomSqlQuery salesPersonQuery = (CustomSqlQuery)dataSource.Queries[0];
salesPersonQuery.Parameters.Add(new QueryParameter("startDate", typeof(Expression),
new Expression("[Parameters.yearParameter] + '/01/01'")));
salesPersonQuery.Parameters.Add(new QueryParameter("endDate", typeof(Expression),
new Expression("[Parameters.yearParameter] + '/12/31'")));
salesPersonQuery.Sql =
"select * from SalesPerson where OrderDate between @startDate and @endDate";
dashboardViewer1.Dashboard = dashboard;
}
public SampleReport()
{
InitializeComponent();
// Initialize a list of lookup values for report columns.
_reportColumns = new LookUpValueCollection()
{
new LookUpValue("ID", "ID"),
new LookUpValue("Name", "Name"),
new LookUpValue("Category", "Category"),
new LookUpValue("Supplier", "Supplier"),
new LookUpValue("UnitPrice", "Price"),
new LookUpValue("UnitsInStock", "In Stock"),
new LookUpValue("UnitsOnOrder", "On Order"),
new LookUpValue("QuantityPerUnit", "Quantity Per Unit")
};
var reportColumnsLookUpSettings = new StaticListLookUpSettings();
reportColumnsLookUpSettings.LookUpValues.AddRange(_reportColumns);
// Assign the list of lookup values to the report's ReportColumns parameter.
this.Parameters["ReportColumns"].LookUpSettings = reportColumnsLookUpSettings;
// Specify default lookup values.
this.Parameters["ReportColumns"].Value = new string[] { "ID", "Name", "Category", "Supplier", "UnitPrice" };
}
public WorksOrderPrint CreateWorksOrderDayPrint()
{
var resources = _appointmentsService.GetAllResources(CurrentTenantId).ToList();
var combinedReport = new WorksOrderPrint {
FilterString = "[WorksAppointmentResourcesId] In (?paramResourceIds)"
};
combinedReport.paramScheduleDate.Value = DateTime.Today;
StaticListLookUpSettings paramResourceIdsSettings = (StaticListLookUpSettings)combinedReport.paramResourceIds.LookUpSettings;
paramResourceIdsSettings.LookUpValues.AddRange(resources.Select(m => new LookUpValue(m.ResourceId, m.Name)));
combinedReport.ParametersRequestBeforeShow += CombinedReport_ParametersRequestBeforeShow;
return(combinedReport);
}
private void AddParameter(Dashboard dashboard)
{
DashboardParameter myDashboardParameter = new DashboardParameter();
StaticListLookUpSettings staticListLookUpSettings1 = new StaticListLookUpSettings();
myDashboardParameter.AllowMultiselect = true;
// Parameter values displayed in the look-up editor.
staticListLookUpSettings1.Values = new string[] { "Alabama", "Ohio", "Utah" };
myDashboardParameter.LookUpSettings = staticListLookUpSettings1;
myDashboardParameter.Name = "parameterState";
myDashboardParameter.Type = typeof(string);
// Default parameter value.
myDashboardParameter.Value = new List <string> {
"Ohio", "Utah"
};
dashboard.Parameters.Add(myDashboardParameter);
}
public static Parameter SetComboBox <TKey>(this Parameter parameter,
IReadOnlyDictionary <TKey, string> lookUpValues,
TKey?value = null) where TKey : struct
{
if (lookUpValues == null)
{
throw new ArgumentNullException(nameof(lookUpValues));
}
parameter.SetType(typeof(TKey?), value);
parameter.MultiValue = false;
var settings = new StaticListLookUpSettings();
settings.LookUpValues.AddRange(lookUpValues.Select(c => new LookUpValue(c.Key, c.Value)));
parameter.LookUpSettings = settings;
return(parameter);
}
public static Parameter SetDrowDown <TKey>(this Parameter parameter,
IReadOnlyDictionary <TKey, string> lookUpValues,
params TKey[] value)
{
if (lookUpValues == null)
{
throw new ArgumentNullException(nameof(lookUpValues));
}
parameter.SetType(typeof(TKey), value);
parameter.MultiValue = true;
var settings = new StaticListLookUpSettings();
settings.LookUpValues.AddRange(lookUpValues.Select(c => new LookUpValue(c.Key, c.Value)));
parameter.LookUpSettings = settings;
return(parameter);
}
static string GetDescription(StaticListLookUpSettings lookupSettings, string value)
{
LookUpValue lookup = lookupSettings.LookUpValues.FirstOrDefault(x => (string)x.Value == value);
return(lookup != null ? lookup.Description : "");
}
