Intersoft Community - WebGrid Enterprise - Remove column name and ID from grouped column on export

Remove column name and ID from grouped column on export

staffan.eriksson@semita.se — Thu, 29 Oct 2009 06:50:43 GMT

In my VB code I added:

WebGrid1.RootTable.GroupedColumns(0).GroupRowValueFormatString = "[value]"

and it works!

It looks like there are bugs regarding doing this any other way.

// Staffan

Remove column name and ID from grouped column on export

james — Thu, 15 Oct 2009 03:53:51 GMT

Staffan, one more thing worth to try.

It seems somehow the exporting process disregards the properties set at column and table level. So you can shoot directly at the group column level. For instance,

grid.RootTable.GroupedColumns[0].GroupRowValueFormatString = "[value]";

Let me know if that does the trick.

Anyhow, if that works, I'll still assume this issue is a bug since the exporting should have take account the other two level of properties (column and table).

Remove column name and ID from grouped column on export

staffan.eriksson@semita.se — Thu, 15 Oct 2009 02:42:12 GMT

I've tried both:

WebGrid1.RootTable.Columns.GetNamedItem("AccountGroupText").GroupRowInfoFormat = "[value]" WebGrid1.RootTable.GroupRowInfoFormatDefault = "[value]"

But it makes no difference. The WebGrid on the screen looks correct but when exporting to pdf for some reason it shows "AccountGroupText: x" on each group header and it's not acceptable for user friendly reasons.

Isn't it possible to loop through each row in the DataDynamics object model and remove the first x characters if it's a group header row?

// Staffan

Remove column name and ID from grouped column on export

james — Thu, 15 Oct 2009 00:17:34 GMT

Staffan,

Okay, it seems like initializing the column property during Export event is too late. I guess that's because the data source is already populated and bound in that event.

Try to set the column property in InitializePostBack event. See the code below.

void WebGrid1_InitializePostBack(object sender, ISNet.WebUI.WebGrid.PostbackEventArgs e)
{
    if (e.Action == PostBackAction.Export)
    {
         WebGrid1.RootTable.Columns.GetNamedItem("AccountGroupText").GroupRowInfoFormat = "[value]"
     }
}

Hope this helps,

James.

Remove column name and ID from grouped column on export

staffan.eriksson@semita.se — Wed, 14 Oct 2009 13:23:11 GMT

In the Export event I've added this code:

WebGrid1.RootTable.Columns.GetNamedItem("AccountGroupText").GroupRowInfoFormat = "[value]"

Unfortunately it still shows "AccountGroupText: x" when exporting. Have I done anything wrong?

// Staffan

Remove column name and ID from grouped column on export

james — Wed, 14 Oct 2009 09:41:22 GMT

Staffan,

It's actually possible to show the text during exporting instead of the value. You can set the EnableValueList property of the export's argument to true during Export event.

Here's the sample codes:

    protected void Page_Load(object sender, EventArgs e)
    {
        WebGrid1.Export += new ISNet.WebUI.WebGrid.ExportEventHandler(WebGrid1_Export);
    }
    void WebGrid1_Export(object sender, ISNet.WebUI.WebGrid.ExportEventArgs e)
    {
        e.ReportInfo.EnableValueList = true;
    }

For the group info format, yes, you can customize that one as well in the Export event. Try setting the GroupRowInfoFormatDefault property to "[value]" (without the double quote). The property is available in global level (LayoutSettings), table level and column level, so you can choose which suits you the best.

Hope this helps,
James.

Remove column name and ID from grouped column on export

staffan.eriksson@semita.se — Wed, 14 Oct 2009 07:58:03 GMT

That's very sad because the built-in exporting functionality can't be used in a real world scenario then.

Is it possible to only show the value and not the column name and value as it does right now?

// Staffan E.

Remove column name and ID from grouped column on export

gordont — Mon, 14 Sep 2009 03:13:02 GMT

Hi,

I am really sorry but it's the default behaviour for exporting in WebGrid, the export result will shows the value instead of the text.

Best Regards,

Gordon Tumewu

Remove column name and ID from grouped column on export

staffan.eriksson@semita.se — Thu, 10 Sep 2009 09:28:34 GMT

I'm grouping my WebGrid 6.0.216 on this column:
<

<ISWebGrid:WebGridColumn CaptionPriceType" DataMember="PriceTypeID" DataType="System.Int32" EditType="DropdownList" InputRequired="True" InputRequiredErrorText="Add price type!" UseValueListForSorting="Yes" Name="PriceTypeID" Width="125px"> <ValueList DataMember="DefaultView" DataSourceID="PriceTypeDataSource" DataTextField="PriceTypeDescription" DataValueField="PriceTypeID"> </ValueList> </ISWebGrid:WebGridColumn>

<GroupedColumns> <ISWebGrid:WebGridGroup ColumnMember="PriceTypeID" GroupInterval="text" SortOrder="Ascending" /> </GroupedColumns>

The text, not the ID of the column is beautifully shown when running the page, but when exporting to pdf it shows "PriceTypeID: 1" instead of the test of the column. How can I remove "PriceTypeID" from the exported pdf and how can I show the text instead of the ID?

// Staffan E.