User Profile & Activity

place Daniel Member
Page
of 2
Posted: February 23, 2010 1:40 PM

It does. It's unfortunate we have to do this, so if it could potentially be considered in a future release that would be great.

Posted: February 22, 2010 7:30 AM

Hi - It is one of the columns. I tried with a few others as well to no avail. Could it be a timing issue with when the grid builds out the columns from the GetReportColumns() and the creation of the groupby column?  If I add it to the .ascx instead of dynamically adding it, it works.

Posted: February 17, 2010 1:38 PM

Found the WebGridFormatCondition tag on the grid. All set.

Posted: February 16, 2010 10:06 AM

Thanks. Worked as expected.

Posted: February 12, 2010 9:10 AM

I implmented the same code except for a few differences. I try to perform the groupby without first clicking on a button. I don't need to run the RetrieveStructure function. If I add the column to the ascx side under the   <roottable> <columns> section like below it works. But I don't know the column names so I can't do that.  Once I remove the WebGridColumn from below it gives me the error assuming oI'm doing my grouping on the vchHHName.  If I try to do my grouping on any other column that I don't include below it fails.

 

<Columns> <iswebgrid:WebGridColumn Caption="vchHHName" DataMember="vchHHName" Name="vchHHName" Width="100px"></iswebgrid:WebGridColumn> </Columns>
Posted: February 11, 2010 10:59 AM

Thanks. That worked!  I actually had to declare the functions in the aspx code the intialize and databinding code. I tried just to use the default functions in the code behind for the grid and some how that didn't work. Now, my dynamic grouping does not work, but I should be able to resolve that. It gives an object reference not found error. I tried placing it in the WebGrid1_PrepareDataBinding event and also the WebGrid1_InitializeLayout to no avail.  I know the column exists. Here's the error and code:

Error: Object reference not set to an instance of an object.

Protected Sub WebGrid1_PrepareDataBinding(ByVal sender As Object, ByVal e As ISNet.WebUI.WebGrid.DataSourceEventArgs) ''set the sorting in here Dim ColumnSet As String = "" Dim columnList As ArrayList = GetReportColumns(True) Dim gridColumn As GridColumn With reportGrid.RootTable

.Columns.Clear()

.SortedColumns.Clear()

.GroupedColumns.Clear() End With For Each gridColumn In columnList Dim col As New WebGridColumn(gridColumn.DisplayName, gridColumn.DataName, gridColumn.DisplayName)

reportGrid.RootTable.Columns.Add(col)

Next Dim groupBy As WebGridGroup = New WebGridGroup()

groupBy.ColumnMember = "vchHHName"

groupBy.GroupInterval = GroupInterval.Text

groupBy.SortOrder = SortOrder.Ascending

reportGrid.RootTable.GroupedColumns.Add(groupBy) ''it errors due to this line

End Sub

Posted: November 13, 2009 12:29 PM

Is it possible to grab the total for the entire group when it covers more than 1 page?  When I implement the below code it only totals the row count for the page I'm on.  I want total for the entire group to display. GroupRowInfoFormat="SupplierID: [value] - ([count])" 

Thanks again!

 

Posted: November 12, 2009 10:07 AM

One last item I forgot to mention.. The XML export is the only one that works 100%. The other export types only pull back the group header text. No detail rows.

-----

Got it to work. Had to remove the RowLayout="ColumnSet" from the settings. Not sure why, but now all the data is exporting as it should.

Posted: November 12, 2009 9:28 AM

I don't get the error when I have the doctype line in below , but no data other than the group by header row is exported into the chosen export file type.  Here are my settings:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <html xmlns="http://www.w3.org/1999/xhtml" > <head id="Head1" runat="server"> <title>Intersoft Sample Grid</title>

</head><

head> <body> <form id="form1" runat="server"> <ISWebGrid:WebGrid ID="WebGrid1" runat="server" UseDefaultStyle="True" DataSourceID="ObjectDataSource1" DefaultStyleMode="Elegant"> <LayoutSettings PagingExportMode="ExportAllData" AllowExport="Yes" AllowColumnMove="Yes" HierarchicalMode="Preload" HideColumnsWhenGrouped="Yes" AllowGrouping="Yes" AllowContextMenu="true" ColumnFooters="Yes" PagingMode="ClassicPaging" AutoHeight="true" AutoWidth="true" StatusBarVisible="true" InProgressUIBehavior="ChangeCursorToHourGlass" PagingDetectPartialGroupRows="true" AllowFilter="Yes" ColumnFooterAggregateMode="CalculateAllData" ColumnSetHeaders="Yes"> </LayoutSettings> <RootTable GroupTotalVisible="true" GroupMode="Expanded" RowLayout="ColumnSet"> <GroupedColumns> <ISWebGrid:WebGridGroup ColumnMember="vchPlanID" SortOrder="Ascending"/> </GroupedColumns> <Columns> <ISWebGrid:WebGridColumn Caption="Rep ID" DataMember="vchPlanID" AllowGrouping="Yes" Name="vchPlanID" GroupRowInfoFormat="Rep ID: [value] ([count])"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Description" DataMember="vchLongName" AllowGrouping="Yes" Name="vchLongName" AllowSorting="Yes"> </ISWebGrid:WebGridColumn>
Posted: November 10, 2009 11:51 AM

Did you ever figure out what was wrong?  I had my export working fine, then I had to change the below line to the new line to get the columns to align up properly.  That worked for my alignment issues, but then I started getting this export error "invalid argument".  I tried setting autoheight and autowidth to no avail.  Any other suggestions?

Old Line

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

New Line

<!
DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
All times are GMT -5. The time now is 9:34 PM.
Previous Next