This is a Content Page
The scriptmanager is on the Master Page
<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Master_Clean.Master" CodeBehind="Proc_Abertos_PG.aspx.vb" Inherits="Clin2013.WebForm25" %>
<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<table style="width:100%;">
<tr>
<td>
<div>
<br />
<asp:RadioButton ID="RadioButton1" runat="server" GroupName="GRP"
Text="Em Aberto" Checked="True" AutoPostBack="True" />
<asp:RadioButton ID="RadioButton2" runat="server" GroupName="GRP"
Text="Fechados" AutoPostBack="True" />
<asp:RadioButton ID="RadioButton3" runat="server" GroupName="GRP"
Text="Todos" AutoPostBack="True" />
<telerik:radcombobox ID="RadComboBox1" Runat="server" AllowCustomText="True"
AutoPostBack="True" DataTextField="Nome"
DataValueField="User_ID" Skin="Telerik">
</telerik:radcombobox>
<asp:Label ID="LblInfo" runat="server" ForeColor="Red"
Text="Dias de Incapacidade > Dias de Incapaciade prevista"></asp:Label>
<asp:Label ID="LblInfo1" runat="server" BackColor="YellowGreen"
Text="Sem Gestor Atribuido"></asp:Label>
<br />
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" Width="50%"
>
</asp:DropDownList>
<br />
<asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" Width="50%"
>
</asp:DropDownList>
<br />
<asp:DropDownList ID="DropDownList3" runat="server" AutoPostBack="True" Width="50%"
>
<asp:ListItem Value="1">Acidentes de Trabalho</asp:ListItem>
<asp:ListItem Value="2">Acidentes Pessoais</asp:ListItem>
<asp:ListItem Value="3">Automóvel</asp:ListItem>
<asp:ListItem Value="4">Patrimoniais/RC</asp:ListItem>
<asp:ListItem Value="5">Todos</asp:ListItem>
</asp:DropDownList>
<br />
<asp:Button ID="Button1" runat="server" Text="Exportar para Excel" />
<asp:Button ID="Button2" runat="server" Text="Exportar para Word" />
<asp:Button ID="Button3" runat="server" Text="Exportar para CSV" />
<br />
<asp:CheckBox ID="CheckBox1" Text="Só dados" runat="server" Checked="True"></asp:CheckBox>
<asp:CheckBox ID="CheckBox2" Text="Todas as paginas" runat="server" Checked="True">
</asp:CheckBox>
<asp:CheckBox ID="CheckBox3" Text="Open exported data in new browser window"
runat="server" Visible="False">
</asp:CheckBox>
<br />
<br />
<telerik:radgrid ID="RadGrid1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" CellSpacing="0"
OnItemDataBound="OnItemDataBoundHandler"
DataSourceID="SqlDataSource1" GridLines="None" Skin="Telerik">
<FilterMenu EnableImageSprites="False"></FilterMenu>
<ClientSettings>
<Selecting AllowRowSelect="True" />
</ClientSettings>
<MasterTableView DataKeyNames="Boletim_id" DataSourceID="SqlDataSource1">
<NoRecordsTemplate>
Sem Registos
</NoRecordsTemplate>
<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
<RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column">
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column">
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
<Columns>
<telerik:GridBoundColumn DataField="Boletim_id" DataType="System.Int32"
FilterControlAltText="Filter Boletim_id column" HeaderText="Boletim_id"
ReadOnly="True" SortExpression="Boletim_id" UniqueName="Boletim_id"
Display="False">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Comp_Processo"
FilterControlAltText="Filter Comp_Processo column" HeaderText="Nº de Processo"
SortExpression="Comp_Processo" UniqueName="Comp_Processo" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CodG"
FilterControlAltText="Filter CodG column" HeaderText="Tipo"
SortExpression="CodG" UniqueName="CodG" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="SG" DataType="System.Int32"
FilterControlAltText="Filter SG column" HeaderText="SG" SortExpression="SG"
UniqueName="SG" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Data_Sinistro" DataType="System.DateTime"
FilterControlAltText="Filter Data_Sinistro column"
HeaderText="Data de Acidente" SortExpression="Data_Sinistro"
UniqueName="Data_Sinistro" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Data_Consulta1" DataType="System.DateTime"
FilterControlAltText="Filter Data_Consulta1 column"
HeaderText="Data 1ª Consulta" SortExpression="Data_Consulta1"
UniqueName="Data_Consulta1" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Data_proxima_Consulta"
DataType="System.DateTime"
FilterControlAltText="Filter Data_proxima_Consulta column"
HeaderText="Data Ultima Consulta" SortExpression="Data_proxima_Consulta"
UniqueName="Data_proxima_Consulta" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Tempo_Incapacidade" DataType="System.Int32"
FilterControlAltText="Filter Tempo_Incapacidade column"
HeaderText="Dias de Incapacidade" SortExpression="Tempo_Incapacidade"
UniqueName="Tempo_Incapacidade" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Expr2" DataType="System.Double"
FilterControlAltText="Filter Expr2 column" HeaderText="Dias Inc.Prevista"
SortExpression="Expr2" UniqueName="Expr2" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Descricao"
FilterControlAltText="Filter Descricao column" HeaderText="Ultima Sit de Inc.Atribuida"
SortExpression="Descricao" UniqueName="Descricao" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Perc" DataType="System.Double"
FilterControlAltText="Filter Perc column" HeaderText="Perc.%"
SortExpression="Perc" UniqueName="Perc" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Expr3"
FilterControlAltText="Filter Expr3 column" HeaderText="Situação"
SortExpression="Expr3" UniqueName="Expr3" ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Gestor_id" DataType="System.Int32"
FilterControlAltText="Filter Gestor_id column" HeaderText="Gestor_id"
SortExpression="Gestor_id" UniqueName="Gestor_id" ReadOnly="True"
Display="False">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Expr1" DataType="System.Int32"
FilterControlAltText="Filter Expr1 column" HeaderText="NºConsultas"
SortExpression="Expr1" UniqueName="Expr1"
ReadOnly="True" Display="False">
</telerik:GridBoundColumn>
<telerik:GridEditCommandColumn EditText="ver"
FilterControlAltText="Filter EditCommandColumn column"
HeaderText="Processo Clinico">
</telerik:GridEditCommandColumn>
</Columns>
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>
</MasterTableView>
</telerik:radgrid>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT Boletins.Boletim_id, Boletins.Comp_Processo, Boletins.CodG, Boletins.SG, Boletins.Data_Sinistro, Boletins.Data_Consulta1, Boletins.Data_proxima_Consulta, Boletins.Tempo_Incapacidade, SUM(Patologias.NºdiasITA) AS Expr2, Tipos_Acompanhamento.Descricao, Boletins.Perc, Tipos_de_Alta.Descricao AS Expr3, Boletins.Gestor_id, COUNT(Consultas_1.Consulta_id) AS Expr1 FROM Consultas AS Consultas_1 INNER JOIN Boletins ON Consultas_1.Boletim_id = Boletins.Boletim_id LEFT OUTER JOIN Consultas INNER JOIN Cons_Patologia INNER JOIN Patologias ON Cons_Patologia.Diagnostico_id = Patologias.Id ON Consultas.Consulta_id = Cons_Patologia.Consulta_id ON Boletins.Boletim_id = Consultas.Boletim_id LEFT OUTER JOIN Tipos_de_Alta ON Boletins.Tipo_Alta_ID = Tipos_de_Alta.Tipo_Alta_ID LEFT OUTER JOIN Tipos_Acompanhamento ON Boletins.Desvalorizacao_ID = Tipos_Acompanhamento.Tipos_Acomp_ID WHERE (Boletins.Fechado = 0) AND (Consultas_1.Realizada = 1) GROUP BY Boletins.Boletim_id, Boletins.Comp_Processo, Boletins.CodG, Boletins.SG, Boletins.Data_Sinistro, Boletins.Data_Consulta1, Boletins.Data_proxima_Consulta, Boletins.Tempo_Incapacidade, Tipos_Acompanhamento.Descricao, Boletins.Perc, Tipos_de_Alta.Descricao, Boletins.Gestor_id ORDER BY Boletins.Data_Sinistro DESC">
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT Gestores.Nome, Gestores.User_ID FROM Gestores INNER JOIN Users ON Gestores.User_ID = Users.Users_ID WHERE (Gestores.TIPO <> N'*')">
</asp:SqlDataSource>
<telerik:radwindowmanager ID="RadWindowManager1" runat="server">
</telerik:radwindowmanager>
<telerik:radformdecorator ID="RadFormDecorator1" Runat="server"
DecoratedControls="Default, Textbox, Textarea, Fieldset, Label, H4H5H6, Select, Zone, GridFormDetailsViews, ValidationSummary"
Skin="Telerik" />
<asp:Label ID="Label200" runat="server" Visible="False" CssClass="label_pequena"></asp:Label>
<asp:Label ID="Label201" runat="server" Visible="False" CssClass="label_pequena"></asp:Label>
<asp:Label ID="Label202" runat="server" Visible="False" CssClass="label_pequena"></asp:Label>
<asp:Label ID="Label203" runat="server" Visible="False" CssClass="label_pequena"></asp:Label>
<asp:Label ID="Label204" runat="server" Visible="False" CssClass="label_pequena"></asp:Label>
<asp:Label ID="LblSender" runat="server" Visible="False" CssClass="label_pequena"></asp:Label>
<asp:Label ID="LblBoletim_id" runat="server" Visible="False" CssClass="label_pequena"></asp:Label>
<asp:Label ID="LblT_Id" runat="server" Visible="False" CssClass="label_pequena"></asp:Label>
<asp:Label ID="Lbldrop1" runat="server" Visible="False" CssClass="label_pequena"></asp:Label>
<asp:Label ID="Lbldrop2" runat="server" Visible="False" CssClass="label_pequena"></asp:Label>
<asp:Label ID="Lbldrop3" runat="server" Visible="False" CssClass="label_pequena"></asp:Label>
<asp:Label ID="LblProduto" runat="server" Visible="False" CssClass="label_pequena"></asp:Label>
<asp:Label ID="LblTipo" runat="server" Visible="False" CssClass="label_pequena"></asp:Label>
<asp:Label ID="LblTipoU" runat="server" Visible="False" CssClass="label_pequena"></asp:Label>
<asp:Label ID="LblGestor_id" runat="server" CssClass="label_pequena"></asp:Label>
<br />
<asp:ListBox ID="ListBox1" runat="server" Visible="False"></asp:ListBox>
</div>
</td>
</tr>
</table>
</asp:Content>