or
|
A |
10 |
|
|
|
|
20 |
|
|
|
A Total |
30 |
AVG |
0.25 (30/120) |
|
B |
20 |
|
|
|
|
30 |
|
|
|
|
40 |
|
|
|
B Total |
90 |
AVG |
0.75(90/120) |
|
Total |
120 |
|
|
Public Sub New() InitializeComponent()End SubPrivate Sub admin_invoice_details_ownitnow_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.NeedDataSource Dim SQL As New StringBuilder SQL.AppendLine(" SELECT ISNULL(products.itemid, 0) AS lotid,") SQL.AppendLine(" invdesc.itemdesc,") SQL.AppendLine(" invdesc.amount") SQL.AppendLine(" FROM invdesc") SQL.AppendLine(" INNER JOIN products ON products.ProductID = invdesc.itemid") SQL.AppendLine(" WHERE invdesc.invoiceid = @invoiceid") Dim sqlDataSource1 As New SqlDataSource() sqlDataSource1.ConnectionString = HttpContext.Current.Session("Conn") sqlDataSource1.SelectCommand = SQL.ToString sqlDataSource1.Parameters.Add("@invoiceid", DbType.Int32, "=Parameters.invoiceid") Me.DataSource = sqlDataSource1End Subprivate void Zoom(object param)
{
ReportChildWindow reportChildWindow = new ReportChildWindow(this.ReportViewer.DataContext);
reportChildWindow.Show();
}
public ReportChildWindow(object dataContext)
{
this.DataContext = dataContext;
InitializeComponent();
}