Skip to main content
Inspiring
October 24, 2013
Question

sub report in column header

  • October 24, 2013
  • 1 reply
  • 1092 views

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,

This topic has been closed for replies.

1 reply

EddieLotter
Inspiring
October 24, 2013

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"?

iccsiAuthor
Inspiring
October 24, 2013

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,