Current filter:
                                You should refresh the page.
                                Support Center
                                0
                                  • I've set up a master detail report that i am trying to assign data at runtime. We use a service.object for all data calls so this cannot be done in the designer. I got everything including a relationship set up, but I get no detailreport detail records? It's nothing fancy and does not return any errors when I run it. Pages are attached. Thanks for your time!

                                DSDetail.zip
                                0

                                Hello Cory.

                                Thank you for your message. This behavior is caused by the fact that you bind the Detail report to an incorrect table. You need to pass the DataRelation's name to the DataMember property to display data correctly. We look forward to your feedback once you have had the opportunity to try our solution.

                                Best regards,
                                Ingvar.

                                0

                                Thanks for your help IngVar! That seeems to have partially fixed it. However, I no data. Just an empty line for each record it should be showing? See attached. I made the following change per your guidance:

                                JensenWS.Service serviceObject = new JensenWS.Service();
                                        DataSet ds = serviceObject.GetDSPrintOrder(Request.QueryString["DSGuid"]);
                                        DataRelation dRelation = new DataRelation("DSHeader_DSDetail", ds.Tables[0].Columns["DSGuid"], ds.Tables[1].Columns["DSGuid"]);
                                        ds.Relations.Add(dRelation);
                                        report.DataSource = ds;
                                        report.DataMember = ds.Tables[0].TableName;
                                        report.DetailReport.DataSource = ds;
                                        //changed here//
                                        report.DetailReport.DataMember = ds.Tables[1].TableName + "." + ds.Relations["DSHeader_DSDetail"].RelationName;
                                        ////////////
                                        rptViewer.Report = report;

                                Capture.JPG
                                0

                                Hello Cory.

                                Thank you for your response. As I can see, you pass an incorrect string to the DetailReport.DataMember property. Please modify it as follows:

                                [C#]
                                report.DetailReport.DataMember = ds.Tables[0].TableName + "." + ds.Relations["DSHeader_DSDetail"].RelationName;

                                In addition, make sure that all DetailReportBand controls refer to this DataRelation fields, but not to ds.Tables[1] fields.

                                If the problem still persists, provide us with a compilable sample project to demonstrate the issue. It will help us find a solution much faster.

                                Best regards,
                                Ingvar.

                                0

                                Thank you so much. I had tried to reference the header table in the relationship, but I did not set the field of the detail report band to the DSHeader_DSDetail in the designer. It's not very intuitive to look for a whole new set of fields that are not in you child table...

                                If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383

                                FOLLOW US

                                DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, Silverlight, ASP.NET, WinForms, HTML5 or Windows 8, DevExpress tools help you build and deliver your best in the shortest time possible.

                                Copyright © 1998-2014 Developer Express Inc.
                                All trademarks or registered trademarks are property of their respective owners