timopp Posted October 10, 2015 Share Posted October 10, 2015 Hi,I am having some trouble with my subreport reproducing results in my main report by the number of rows produced in the subreport. So if my subreport has three rows in it, the main report will produce three subreport sections, each with three rows in it. I hope I have explained this well enoughI know this is something really easy, but I have jacked with it all day.TIA Tim Link to comment Share on other sites More sharing options...
zh3ntil Posted October 11, 2015 Share Posted October 11, 2015 Hi,It seems your main dataset query generates three rows and you subreport is on detail band. Put subreport on summary band or change main dataset as generating one dummy record if it is not in use. Link to comment Share on other sites More sharing options...
timopp Posted October 11, 2015 Author Share Posted October 11, 2015 Thanks.Could you detail this part?or change main dataset as generating one dummy record if it is not in use.Tim Link to comment Share on other sites More sharing options...
zh3ntil Posted October 11, 2015 Share Posted October 11, 2015 If your main dataset result doesn't fill any field on main report, you can use a query like 'select 1 as field' just to be sure the dataset returns at least a row. Because if your dataset returns no result, your report shows no data section. So, If your main dataset returns a dummy result like that just a row, your detail section runs just one time. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now