How to restrict the content of a sub report



In my main report, in detail band, I have a subreport and a text field placed vertically next to one  another.

I have fixed the text field height and unmarked the stretch with overflow option. Because, i want the data to be fit in container and it is fine even if it truncates some data. I want the same thing to be hapened with sub report. I don't want it to get stretched by data. But if that sub report has huge data, it's getting stretched and all data is displayed.

How can I limit the size that no matter what the subreport data is, it won't take more than the defined band height ????? 
or any other options to solve my problem ?



agrawalmanisha14's picture
Joined: Nov 30 2015 - 1:21am
Last seen: 7 months 3 days ago

Yes, i need it. It's query cant be clubbed with the main query. Hence, i need to go for a sub report.

How i can limit the number of rows? or any other way to restrict the data content in subreport?



agrawalmanisha14 - 4 years 7 months ago

1 Answer:


You can limit the number of row used in a subreport. Anyways, do you actually need a subreport?

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 1 year 2 months ago