Export row details

[Calin Calin]

Hi,

I have a grid that has as details for each row a different grid (kind like of a invoice / invoice lines). I need to export this grid to a excel document and show the rows like this:

- row1

-r1detail1

-r1detail2

-r1detail3

- row2

-r2detail1

-r2detail2

...

Is there any way I can accomplish this ?

Thank you,

Calin

[Pavel Pavlov]

Hi Calin Calin,

I am afraid this is still not supported by RadGridView as internal feature.

Regards,
Pavel Pavlov
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Calin Calin]

Hi Pavel,

Any ideea how can I achieve this ?

I was thinking to break the stream after each row was exported and export the grid from the details in the same stream.

Is there a way to get after the a row was exported ?

If I manage to have a implementation on this I will post it here and maybe you guys can port it as a sample. If should be pretty useful.

Regards,

[Vlad]

Hi Calin,

With our upcoming latest build you will be able to achieve this using our new ElementExported event. You will have access to the StreamWriter and you will be able to write additional data to the stream. For example:

private void RadGridView1_ElementExported(object sender, GridViewElementExportedEventArgs e)
{
    if (e.Element == ExportElement.Row)
    {
        var obj = e.Context as MyBusinessObject;
        if (obj != null)
        {
            e.Writer.Write(String.Format(@"<tr><td background-color:#CCC;"" colspan=""{0}"">",
                RadGridView1.Columns.Count));

            e.Writer.Write(String.Format(@"ID: {0} <br />", obj.ID));
            e.Writer.Write(String.Format(@"Name: {0} <br />", obj.Name));

            e.Writer.Write("</td></tr>");
        }
    }
}

I've attached an example project with our latest binaries plus Excel output.

Greetings,
Vlad
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Joe]

This is not intended, is it?
So, i have something like this:

row1
column1
column2
colum3
row1_rowdetails
    rowdetails1
    rowdetails2
row2
column1
column2
colum3
row2_rowdetails
    rowdetails1
    rowdetails2

how can I get both row columns and rowdetails exported?