Prevent Sub Report Growin

[russr999]

Hi,

I have a main report with a databand.
Within this report I have a sub report. The sub report page size is 200 x 10.
The sub report control on the main report is also 200 x 10.
My problem is that if more data exists in the sub report, it expanss to show all the data.

How can I stop the sub report from growing?

Thanks

[HighAley]

Hello.

Unfortunately, it's impossible to stop growing of the Sub-report.
You should set the right filter of this Band.

Thank you.

[russr999]

Thanks for the reply....

What I have done to get around this is to change my subreport queries to use parameter values (in the WHERE clause) where the parameter is equal to the primary key of the main report and having the query limited to only return only TOP x records based on the ORDER BY clause of the query....slows up the report but is worth it

Thanks for the help

[Alex K.]

Hello,

Ok.
Let us know if you have any additional questions.