Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <telerik:RadGrid ID="RadGrid1" runat="server" ShowFooter="false" AutoGenerateColumns="false"
- AllowPaging="true" AllowSorting="false" CellSpacing="5" AllowFilteringByColumn="false">
- <ExportSettings HideStructureColumns="true" ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true">
- <Pdf AllowAdd="false" AllowCopy="true" AllowModify="false" AllowPrinting="true" PageTitle="ESign Sent vs Sold"
- Title="ESign Sent vs Sold" PaperSize="A4" PageWidth="260mm" />
- <Excel Format="Html" />
- </ExportSettings>
- <ClientSettings AllowExpandCollapse="true">
- <Selecting AllowRowSelect="true" />
- </ClientSettings>
- <MasterTableView DataKeyNames="ParentID, ID" Name="DivisionTable" HierarchyLoadMode="Client" HierarchyDefaultExpanded="false" ClientDataKeyNames="ParentID, ID">
- <HeaderStyle Font-Bold="true" HorizontalAlign="Left" Wrap="false" />
- <ItemStyle Wrap="false" VerticalAlign="Middle" HorizontalAlign="Left" />
- <AlternatingItemStyle Wrap="false" VerticalAlign="Middle" HorizontalAlign="Left" />
- <FooterStyle Wrap="false" />
- <DetailTables>
- <telerik:GridTableView Name="RegionTable" DataKeyNames="ParentID, ID" ClientDataKeyNames="ParentID, ID" HierarchyLoadMode="Client" Width="100%" HierarchyDefaultExpanded="false" >
- <DetailTables>
- <telerik:GridTableView Name="BranchTable" DataKeyNames="ParentID, ID" ClientDataKeyNames="ParentID, ID" HierarchyLoadMode="Client" Width="100%" HierarchyDefaultExpanded="false" >
- <Columns>
- <telerik:GridTemplateColumn UniqueName="Filler" ItemStyle-Width="25px" HeaderStyle-Width="25px">
- <ItemTemplate>
- <span> </span>
- </ItemTemplate>
- </telerik:GridTemplateColumn>
- <telerik:GridBoundColumn UniqueName="Text" DataField="Text" SortExpression="Text" HeaderText="Branch" ItemStyle-Width="300px" HeaderStyle-Width="300px" />
- <telerik:GridBoundColumn UniqueName="SentCount" DataField="SentCount" SortExpression="SentCount" HeaderText="ESign Sent" ItemStyle-Width="150px" HeaderStyle-Width="150px" />
- <telerik:GridBoundColumn UniqueName="SoldCount" DataField="SoldCount" SortExpression="SoldCount" HeaderText="Sold w/ ESign" />
- </Columns>
- </telerik:GridTableView>
- </DetailTables>
- <Columns>
- <telerik:GridBoundColumn UniqueName="Text" DataField="Text" SortExpression="Text" HeaderText="Region" ItemStyle-Width="300px" HeaderStyle-Width="300px" />
- <telerik:GridBoundColumn UniqueName="SentCount" DataField="SentCount" SortExpression="SentCount" HeaderText="ESign Sent" ItemStyle-Width="150px" HeaderStyle-Width="150px" />
- <telerik:GridBoundColumn UniqueName="SoldCount" DataField="SoldCount" SortExpression="SoldCount" HeaderText="Sold w/ ESign" />
- </Columns>
- </telerik:GridTableView>
- </DetailTables>
- <Columns>
- <telerik:GridBoundColumn UniqueName="Text" DataField="Text" SortExpression="Text" HeaderText="Division" ItemStyle-Width="300px" HeaderStyle-Width="300px" />
- <telerik:GridBoundColumn UniqueName="SentCount" DataField="SentCount" SortExpression="SentCount" HeaderText="ESign Sent" ItemStyle-Width="150px" HeaderStyle-Width="150px" />
- <telerik:GridBoundColumn UniqueName="SoldCount" DataField="SoldCount" SortExpression="SoldCount" HeaderText="Sold w/ ESign" />
- </Columns>
- </MasterTableView>
- </telerik:RadGrid>
- protected void btnExport_Click(object sender, EventArgs e)
- {
- Response.Clear();
- Response.Buffer = true;
- Response.ContentType = "application/vnd.ms-excel";
- Response.Charset = "";
- this.EnableViewState = false;
- System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
- System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
- RadGrid1.RenderControl(oHtmlTextWriter);
- Response.Write(oStringWriter.ToString());
- Response.End();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement