Hi all,
Can anyone suggest me how to export all records from ultrawebgrid? Only current page is exported to excel. but pdf seems to be ok.
I made allowpages =false and then bind and export.
I referred
http://forums.infragistics.com/forums/p/2865/16661.aspx#16661
http://forums.infragistics.com/search/SearchResults.aspx?q=export+page&s=192
http://news.infragistics.com/forums/p/9792/72685.aspx
Issue not solved. Kindly suggest.
Thanks!
Hello,
Indeed, I have seen this reported often. This is solved by resetting the grid to its default state, e.g.
1. Make sure Load On Demand or any Browser / Xml setting are not set
2. Disable all paging settings, including AllowPaging. PageSize, etc
3. Make sure you rebind the grid with the new settings prior to exporting
If none of these helps, could you please paste some of your grid ASPX setting and the code you are using for exporting -- this will surely provide additional clues.
Hi,
Thanks for your reply.
Code in excel button click:
TList<UsersTest> searchList = (TList<UsersTest>)Session["UsersTest"
];
ugUserGroupList.Browser =
BrowserLevel
.Auto;
ugUserGroupList.DisplayLayout.LoadOnDemand =
LoadOnDemand
.NotSet;
ugUserGroupList.DisplayLayout.Pager.CurrentPageIndex = 1;
ugUserGroupList.DisplayLayout.Pager.AllowPaging =
false
;
ugUserGroupList.DisplayLayout.Pager.AllowCustomPaging =
ugUserGroupList.DisplayLayout.Pager.MinimumPagesForDisplay = 0;
ugUserGroupList.DisplayLayout.Pager.NextText =
"Next"
ugUserGroupList.DisplayLayout.Pager.PagerAppearance =
PagerAppearance
.Bottom;
ugUserGroupList.DisplayLayout.Pager.PageSize = 8;
ugUserGroupList.DisplayLayout.Pager.Pattern =
"[default]"
ugUserGroupList.DisplayLayout.Pager.PrevText =
"Prev"
ugUserGroupList.DisplayLayout.Pager.QuickPages = 2;
ugUserGroupList.DisplayLayout.Pager.StyleMode =
PagerStyleMode
.Numeric;
//ugUserGroupList.DisplayLayout.Pager.
ugUserGroupList.DataSource = searchList;
ugUserGroupList.DataBind();
//ugUserGroupList.Columns.FromKey("Id").Hidden = true;
//ugUserGroupList.Columns.FromKey("Status").DataType = typeof(String).ToString();
UltraWebGridExcelExporter1.DownloadName =
DateTime.Now.ToString("yyyyMMdd hhmm") + "UsersTestList"
Display Layout of Grid:
<displaylayout allowcolsizingdefault="Free" allowcolumnmovingdefault="OnServer"
allowdeletedefault="No" allowsortingdefault="OnClient" AllowRowNumberingDefault="Continuous"
bordercollapsedefault="Separate"
headerclickactiondefault="SortMulti" name="uwgSearchList"
rowheightdefault="20px" rowselectorsdefault="No"
selecttyperowdefault="Extended" stationarymargins="Header"
stationarymarginsoutlookgroupby="True" tablelayout="Fixed" version="4.00"
viewtype="Flat" NoDataMessage="No Records found"
AutoGenerateColumns="False" CellClickActionDefault="RowSelect">
<framestyle backcolor="window" bordercolor="InactiveCaption"
borderstyle="Solid" borderwidth="1px" font-names="Microsoft Sans Serif"
font-size="8.25pt" ForeColor="#404040">
</framestyle>
<HeaderStyleDefault BackColor="#196155" Cursor="hand" Font-Names="Verdana" Font-Size="10px" Font-Bold="true" ForeColor="white">
<Padding Left="3px"/>
</HeaderStyleDefault>
<SelectedRowStyleDefault BackColor="#5ccf93"></SelectedRowStyleDefault>
<pager Alignment="Right" AllowPaging="True" PageSize="10">
<PagerStyle BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
<borderdetails colorleft="White" colortop="White" widthleft="1px"
widthtop="1px" />
</PagerStyle>
</pager>
<editcellstyledefault borderstyle="None" borderwidth="0px">
</editcellstyledefault>
<footerstyledefault backcolor="LightGray" borderstyle="Solid" borderwidth="1px">
</footerstyledefault>
<RowStyleDefault BackColor="Window" BorderColor="#405b12" BorderStyle="solid" BorderWidth="1px"
Font-Names="Verdana" Font-Size="10px" ForeColor="black">
<Padding Left="5px" />
</RowStyleDefault>
<RowAlternateStyleDefault BackColor="#e2fcdf"></RowAlternateStyleDefault>
<groupbyrowstyledefault backcolor="Control" bordercolor="Window">
</groupbyrowstyledefault>
<groupbybox Hidden="True">
<boxstyle backcolor="ActiveBorder" bordercolor="Window">
</boxstyle>
</groupbybox>
<activationobject bordercolor="" borderwidth="">
</activationobject>
<filteroptionsdefault>
<filterdropdownstyle backcolor="White" bordercolor="Silver" borderstyle="Solid"
borderwidth="1px" customrules="overflow:auto;"
font-names="Verdana,Arial,Helvetica,sans-serif" font-size="11px" height="300px"
width="200px">
<padding left="2px" />
</filterdropdownstyle>
<filterhighlightrowstyle backcolor="#151C55" forecolor="White">
</filterhighlightrowstyle>
<filteroperanddropdownstyle backcolor="White" bordercolor="Silver"
borderstyle="Solid" borderwidth="1px" customrules="overflow:auto;"
font-names="Verdana,Arial,Helvetica,sans-serif" font-size="11px">
</filteroperanddropdownstyle>
</filteroptionsdefault>
</displaylayout>
Note: For paging, I'm using pattern.
Kindly suggest.
It is very difficult for me to debug the program at this point. From what I can tell, everything seems fine, but there must be something that gets in the way.
Can you please open a support tickets with our official Developer Support channels and send a sample subtset of this project reproducing the issue? Developer support can be reached at:
http://es.infragistics.com/Support/default.aspx#Overview