skwilliamson 0 Newbie Poster

I'd like to select a week and pull data based on that week. Data selection starts on line 616.

Thanks.

<%@ Page Language="VB" AutoEventWireup="false" Debug="True" %>

<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
    Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

<!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>Weekly Reprints</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table style="width: 736px; height: 456px">
            <tr>
                <td colspan="3" style="height: 25px; text-align: center">
                    <span style="font-size: 16pt"><strong>Weekly Reprints</strong></span></td>
            </tr>
            <tr>
                <td colspan="2" style="width: 238px; height: 25px; text-align: left">
                    <asp:Calendar ID="Calendar1" runat="server" BackColor="White" BorderColor="Black"
                        DayNameFormat="Shortest" Font-Names="Times New Roman" Font-Size="10pt" ForeColor="Black"
                        Height="144px" NextPrevFormat="FullMonth" TitleFormat="Month" Width="224px" SelectionMode="DayWeek">
                        <SelectedDayStyle BackColor="#CC3333" ForeColor="White" />
                        <SelectorStyle BackColor="#CCCCCC" Font-Bold="True" Font-Names="Verdana" Font-Size="8pt"
                            ForeColor="#333333" Width="1%" />
                        <TodayDayStyle BackColor="#CCCC99" />
                        <OtherMonthDayStyle ForeColor="#999999" />
                        <DayStyle Width="14%" />
                        <NextPrevStyle Font-Size="8pt" ForeColor="White" />
                        <DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" ForeColor="#333333"
                            Height="10pt" />
                        <TitleStyle BackColor="Black" Font-Bold="True" Font-Size="13pt" ForeColor="White"
                            Height="14pt" />
                    </asp:Calendar>
                </td>
                <td colspan="2" style="height: 25px; text-align: left; width: 249px;">
                    Weekly Total Parts
                </td>
            </tr>
            <tr>
                <td colspan="3" style="height: 288px">
                    <table style="border-top-style: outset; border-right-style: outset; border-left-style: outset; border-bottom-style: outset" border="1" frame="border">
                        <tr>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                            </td>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                2009</td>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                2008</td>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                Goal</td>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                % Actual</td>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                % Goal</td>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                +/- %</td>
                        </tr>
                        <tr>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                Customer Service</td>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                <asp:FormView ID="FormView1" runat="server" DataSourceID="AccessDataSource1">
                                    <EditItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                                            Text="Update">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </EditItemTemplate>
                                    <InsertItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
                                            Text="Insert">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </InsertItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
                                    </ItemTemplate>
                                </asp:FormView>
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                OT/Billing</td>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                <asp:FormView ID="FormView2" runat="server" DataSourceID="AccessDataSource2">
                                    <EditItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                                            Text="Update">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </EditItemTemplate>
                                    <InsertItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
                                            Text="Insert">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </InsertItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
                                    </ItemTemplate>
                                </asp:FormView>
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                Preflight</td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                                <asp:FormView ID="FormView3" runat="server" DataSourceID="AccessDataSource8">
                                    <EditItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                                            Text="Update">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </EditItemTemplate>
                                    <InsertItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
                                            Text="Insert">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </InsertItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
                                    </ItemTemplate>
                                </asp:FormView>
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                Manual Edit</td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                                <asp:FormView ID="FormView4" runat="server" DataSourceID="AccessDataSource4">
                                    <EditItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                                            Text="Update">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </EditItemTemplate>
                                    <InsertItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
                                            Text="Insert">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </InsertItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
                                    </ItemTemplate>
                                </asp:FormView>
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                Proof Center</td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                                <asp:FormView ID="FormView5" runat="server" DataSourceID="AccessDataSource7">
                                    <EditItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                                            Text="Update">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </EditItemTemplate>
                                    <InsertItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
                                            Text="Insert">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </InsertItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
                                    </ItemTemplate>
                                </asp:FormView>
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                Data</td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                                <asp:FormView ID="FormView6" runat="server" DataSourceID="AccessDataSource2">
                                    <EditItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                                            Text="Update">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </EditItemTemplate>
                                    <InsertItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
                                            Text="Insert">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </InsertItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
                                    </ItemTemplate>
                                </asp:FormView>
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                Imprint</td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                                <asp:FormView ID="FormView7" runat="server" DataSourceID="AccessDataSource3">
                                    <EditItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                                            Text="Update">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </EditItemTemplate>
                                    <InsertItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
                                            Text="Insert">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </InsertItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
                                    </ItemTemplate>
                                </asp:FormView>
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                                10</td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                Shipping</td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                                <asp:FormView ID="FormView8" runat="server" DataSourceID="AccessDataSource9">
                                    <EditItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                                            Text="Update">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </EditItemTemplate>
                                    <InsertItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
                                            Text="Insert">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </InsertItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
                                    </ItemTemplate>
                                </asp:FormView>
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                                11</td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                                Misc</td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                                <asp:FormView ID="FormView9" runat="server" DataSourceID="AccessDataSource5">
                                    <EditItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                                            Text="Update">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </EditItemTemplate>
                                    <InsertItemTemplate>
                                        dtDate:
                                        <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
                                        </asp:TextBox><br />
                                        Ct:
                                        <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
                                        </asp:TextBox><br />
                                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
                                            Text="Insert">
                                        </asp:LinkButton>
                                        <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                            Text="Cancel">
                                        </asp:LinkButton>
                                    </InsertItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
                                    </ItemTemplate>
                                </asp:FormView>
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 100px; text-align: center; vertical-align: middle;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                            <td style="width: 100px; vertical-align: middle; text-align: center;">
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
            <tr>
                <td rowspan="2" style="width: 100px">
                    &nbsp; &nbsp;&nbsp;&nbsp;
                </td>
                <td colspan="2" style="width: 238px">
                    <table>
                        <tr>
                            <td style="width: 100px; background-color: aqua; text-align: center">
                                Line</td>
                            <td style="width: 100px; background-color: aqua; text-align: center">
                                Parts</td>
                            <td style="width: 100px; background-color: aqua; text-align: center">
                                Reprints</td>
                            <td style="width: 100px; background-color: aqua; text-align: center">
                                %</td>
                        </tr>
                        <tr>
                            <td style="width: 143px">
                                Ws-Social</td>
                            <td style="width: 100px">
                            </td>
                            <td style="width: 100px">
                            </td>
                            <td style="width: 100px">
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 143px">
                                Dm-Social</td>
                            <td style="width: 100px">
                            </td>
                            <td style="width: 100px">
                            </td>
                            <td style="width: 100px">
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 143px">
                                Ws-Xmas</td>
                            <td style="width: 100px">
                            </td>
                            <td style="width: 100px">
                            </td>
                            <td style="width: 100px">
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 143px">
                                Dm-Xmas</td>
                            <td style="width: 100px">
                            </td>
                            <td style="width: 100px">
                            </td>
                            <td style="width: 100px">
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 143px">
                                Total</td>
                            <td style="width: 100px">
                            </td>
                            <td style="width: 100px">
                            </td>
                            <td style="width: 100px">
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
            <tr>
                <td colspan="2" style="width: 238px; height: 88px">
                    &nbsp;
                    <table>
                        <tr>
                            <td style="width: 100px; background-color: aqua; text-align: center">
                                Orders</td>
                            <td style="width: 100px; background-color: aqua; text-align: center">
                                Reprints</td>
                            <td style="width: 100px; background-color: aqua; text-align: center">
                                %</td>
                        </tr>
                        <tr>
                            <td style="width: 100px; text-align: center">
                            </td>
                            <td style="width: 100px; text-align: center">
                            </td>
                            <td style="width: 100px; text-align: center">
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
        </table>
    
    </div>
        <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/MPD.mdb"
            SelectCommand="SELECT * FROM [qryRpCs1] WHERE ([dtDate] = ?)">
            <SelectParameters>
                <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
                    Type="DateTime" />
            </SelectParameters>
        </asp:AccessDataSource>
        <asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/MPD.mdb"
            SelectCommand="SELECT * FROM [qryRpData1] WHERE ([dtDate] = ?)">
            <SelectParameters>
                <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
                    Type="DateTime" />
            </SelectParameters>
        </asp:AccessDataSource>
        <asp:AccessDataSource ID="AccessDataSource3" runat="server" DataFile="~/MPD.mdb"
            SelectCommand="SELECT * FROM [qryRpImprint1] WHERE ([dtDate] = ?)">
            <SelectParameters>
                <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
                    Type="DateTime" />
            </SelectParameters>
        </asp:AccessDataSource>
        <asp:AccessDataSource ID="AccessDataSource4" runat="server" DataFile="~/MPD.mdb"
            SelectCommand="SELECT * FROM [qryRpMe1] WHERE ([dtDate] = ?)">
            <SelectParameters>
                <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
                    Type="DateTime" />
            </SelectParameters>
        </asp:AccessDataSource>
        <asp:AccessDataSource ID="AccessDataSource5" runat="server" DataFile="~/MPD.mdb"
            SelectCommand="SELECT * FROM [qryRpMisc1] WHERE ([dtDate] = ?)">
            <SelectParameters>
                <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
                    Type="DateTime" />
            </SelectParameters>
        </asp:AccessDataSource>
        <asp:AccessDataSource ID="AccessDataSource6" runat="server" DataFile="~/MPD.mdb"
            SelectCommand="SELECT * FROM [qryRpOt1] WHERE ([dtDate] = ?)">
            <SelectParameters>
                <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
                    Type="DateTime" />
            </SelectParameters>
        </asp:AccessDataSource>
        <asp:AccessDataSource ID="AccessDataSource7" runat="server" DataFile="~/MPD.mdb"
            SelectCommand="SELECT * FROM [qryRpPfCtr1] WHERE ([dtDate] = ?)">
            <SelectParameters>
                <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
                    Type="DateTime" />
            </SelectParameters>
        </asp:AccessDataSource>
        <asp:AccessDataSource ID="AccessDataSource8" runat="server" DataFile="~/MPD.mdb"
            SelectCommand="SELECT * FROM [qryRpPreflight1] WHERE ([dtDate] = ?)">
            <SelectParameters>
                <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
                    Type="DateTime" />
            </SelectParameters>
        </asp:AccessDataSource>
        <asp:AccessDataSource ID="AccessDataSource9" runat="server" DataFile="~/MPD.mdb"
            SelectCommand="SELECT * FROM [qryRpShipping1] WHERE ([dtDate] = ?)">
            <SelectParameters>
                <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
                    Type="DateTime" />
            </SelectParameters>
        </asp:AccessDataSource>
        <br />
    </form>
</body>
</html>