Page 1 of 1

Prevent Sub Report Growin

Posted: Sun Nov 29, 2015 12:53 pm
by 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

Re: Prevent Sub Report Growin

Posted: Mon Nov 30, 2015 7:52 am
by HighAley
Hello.

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

Thank you.

Re: Prevent Sub Report Growin

Posted: Mon Nov 30, 2015 11:04 am
by 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

Re: Prevent Sub Report Growin

Posted: Tue Dec 01, 2015 6:53 am
by Alex K.
Hello,

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