Nested content issue.

[Will]

I am trying to represent nested data in a report. The data structure just likes Master View and Detailed Tables in Radgrid.
Put simply,how to show the data in a report which has a relationship like Order and Order Details.
I've tried many ways to achieve it but never success.
I know how the demo Invoice works,but I can't modify it to achieve my goal.
I wish some one could help to get through this.
Thanks in advance.

[Will]

It looks like this.I hope this picture could be useful to make you understand.
I love the export to pdf function.so it has to be represent in Reporting.

[Will]

Is it possible that using the Telerik.Reporting.Table like System.Web.UI.WebControls.Table.
I mean using like below.

System.Web.UI.WebControls.Table itinerary = new System.Web.UI.WebControls.Table();
                foreach (var i in service.GetGroupItineraries(new Guid(groupId)))
                {
                    TableRow itineraryrow = new TableRow();
                    itineraryrow.CssClass = "datagridtableheader";

                    System.Web.UI.WebControls.TableCell date = new System.Web.UI.WebControls.TableCell();
                    System.Web.UI.WebControls.TableCell title = new System.Web.UI.WebControls.TableCell();
                    System.Web.UI.WebControls.TableCell serviceDescription = new System.Web.UI.WebControls.TableCell();

                    date.Text = i.ItineraryDate.ToString("ddd ") + i.ItineraryDate.ToString("dd MMM yy");
                    //date.Text = i.ItineraryDate.ToString("dd MMM yy");

                    title.Text = i.Title;
                    serviceDescription.Text = i.ServiceDescription;

                    itineraryrow.Cells.Add(date);
                    itineraryrow.Cells.Add(title);
                    itineraryrow.Cells.Add(serviceDescription);

                    itinerary.Rows.Add(itineraryrow);
                    foreach (var d in service.GetGroupItineraryDetails(i.Id))
                    {
                        TableRow detailrow = new TableRow();
                        System.Web.UI.WebControls.TableCell starttime = new System.Web.UI.WebControls.TableCell();
                        System.Web.UI.WebControls.TableCell arrangement = new System.Web.UI.WebControls.TableCell();
                        System.Web.UI.WebControls.TableCell description = new System.Web.UI.WebControls.TableCell();

                        starttime.Text = d.StartTime.ToString();
                        arrangement.Text = d.DetailName;
                        arrangement.Attributes["style"] = string.Format("text-align:left;");

                        description.Text = d.Description;
                        description.Attributes["style"] = string.Format("text-align:left;");

                        detailrow.Cells.Add(starttime);
                        detailrow.Cells.Add(arrangement);
                        detailrow.Cells.Add(description);

                        itinerary.Rows.Add(detailrow);
                    }

                }

[Stef]

Hello Will,

You can use groupings in the report to achieve the hierarchical representation of data in the report. The GroupHeader will have the data fields common for the group, and in the Detail section will be the rest of the fields.

For more details, please check the following articles:

• ReportWizard
• Grouping Data and How to: Add groups to Report

You can also take a look at the attached report in XML format.


I hope this helps you.

Regards,
Stef
Telerik

 

 

[Will]

Hi Stef
Thank you very much,I 've achieved my goal.
I get one more question that is it possible to use Reporting in the Asp.net MVC project.

[Stef]

Hello Will,

You can use the ReportProcessor to export reports and return the file result to the client directly. You can also use the new HTML5 Report Viewer and the Reporting REST Service.

More details about using the HTML5 Report Viewer can be found in my post here.

Regards,
Stef
Telerik