locked
plz urgently i m stuck in creating sub reports RRS feed

  • Question

  • User-1321950442 posted

    i have a parent report to display supliers

    for each suplier i display a subreport for products

    i crystal its ok but when i create asp.net page and report viewer no products display

    only supliers of parent report

    but child report does not display

            <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="True"
                EnableDatabaseLogonPrompt="False" Height="1039px" ReportSourceID="CrystalReportSource1"
                Width="901px" />
            <CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
                <Report FileName="CrystalReportParent.rpt">
                </Report>
            </CR:CrystalReportSource>
            <br />
            &nbsp;<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
                SelectCommand="SELECT [SupplierID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax], [HomePage] FROM [Suppliers]">
            </asp:SqlDataSource>
     
    i use sql data source 
     
    C# cod e behind
     
        protected void Page_Load(object sender, EventArgs e)
        {
            CrystalReportSource1.ReportDocument.SetDataSource(SqlDataSource1.Select(DataSourceSelectArguments.Empty));
        }
    
    the source code is here 
    http://www.4shared.com/file/aT84I0--/WebSite1.html
    plz advice 
    what am i missing ????
    Sunday, June 26, 2011 7:16 AM

Answers

  • User363754837 posted

    Did you make your subreport as a linked report so when you click on the link it takes you right to it.

    Sub reports as usually linked at the footer of your report

    hope this helps

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 28, 2011 9:33 AM