using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Windows.Forms;
using System.Drawing;
using System.Data;
using FastReport;
using FastReport.Data;
using FastReport.Dialog;
using FastReport.Barcode;
using FastReport.Table;
using FastReport.Utils;
namespace FastReport
{
public class ReportScript
{
private void btnOk_Click(object sender, EventArgs e)
{
//Report.SetParameterValue("OrderBy", cboOrderBy.Text); DOES NOT WORK ?????
TableDataSource tEmails = Report.GetDataSource("emails_sent_history") as TableDataSource;
string orderBy = String.Empty;
if (cboOrderBy.Text == "Date")
orderBy = "`Date`";
else if (cboOrderBy.Text == "Transaction Type")
orderBy = "TransType";
else if (cboOrderBy.Text == "Recipient")
orderBy = "Recipient";
else if (cboOrderBy.Text == "Status")
orderBy = "Status";
tEmails.SelectCommand = tEmails.SelectCommand.ToString().Replace("@OrderBy", orderBy);
string selection = String.Empty;
if (cboSelection.Text == "All")
{
txtSelectionFeedback.Text = "Selection: All";
selection = "ID > 0";
}
else if (cboSelection.Text == "Failed Only")
{
txtSelectionFeedback.Text = "Selection: Failed Only";
selection = "Failed = 1";
}
else if (cboSelection.Text == "Success Only")
{
txtSelectionFeedback.Text = "Selection: Success Only";
selection = "Failed = 0";
}
tEmails.SelectCommand = tEmails.SelectCommand.ToString().Replace("@Selection", selection);
}
private void Form1_Shown(object sender, EventArgs e)
{
cboSelection.Text = "All";
cboOrderBy.Text = "Date";
}
}
}