2 Replies Latest reply: Oct 24, 2013 10:41 AM by iccsi RSS

    sub report in column header

    iccsi Community Member
    iccsi Oct 24, 2013 8:48 AM

      Infinite loop creating new page due to column header overflow.

       

      I have a sub report on the column header which works,

      Because my sub report return different records from data source, it fails and get infinite loop error message like above when I have 9 records, it works less than 9 records.

       

      I would like to know my sub report returns records some times more, are there any place for my subreport?

      Are there limit for sub report?

       

      Your help and information is great appreciated,

       

      Regards,

       

      Iccsi,

      • 423 Views
      • Tags:
        • 1. Re: sub report in column header
          Eddie Lotter Community Member
          Eddie Lotter Oct 24, 2013 10:34 AM (in response to iccsi)

          iccsi wrote:

           

          Because my sub report return different records from data source, it fails and get infinite loop error message like above when I have 9 records, it works less than 9 records.

           

          What do you mean by "return different records from data source"?

          • 2. Re: sub report in column header
            iccsi Community Member
            iccsi Oct 24, 2013 10:41 AM (in response to Eddie Lotter)

            Thanks for the message and help,

            My sub report link to a data soruce which is a stroed procedure running from MS SQL server.

             

            The stroed procedure returns data based on data base what data in the table.

            It looks like the sub report on the Report Builder limited by the length of the report band.

             

            I tried to move to column header, column footer, report footer all the same, when the sub report growth then it fails to generate the reports.

             

            Regards,

             

            Iccsi,