sub report in column header

[iccsi]

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,

[EddieLotter]

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

[iccsi]

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,