thomas.frommelt Posted July 19, 2013 Share Posted July 19, 2013 Hello,in my report i have an sub report in a group. If this sub report ist empty, my group (where the subreport is in) in the main report should not printed on the report. Becouse i would like to avoid empty space on the report.How can i do this?Thanks Link to comment Share on other sites More sharing options...
ajinkya_c Posted July 19, 2013 Share Posted July 19, 2013 Hi,You can try to write condition in print when expression of group where condition is if report count of subreport not 0 then print that group so that it hides band when subreport is empty. I am not sure about this but may be possible solution that you can try.Regards,Ajinkya Link to comment Share on other sites More sharing options...
thomas.frommelt Posted July 19, 2013 Author Share Posted July 19, 2013 Thanks for your answer. Unfortunately this didn't work. The value of the subreport_count is always 0.I think the "print when expression" of the group, was evaluatet befor the sub report starts. Do you habe any other idear. Link to comment Share on other sites More sharing options...
ajinkya_c Posted July 19, 2013 Share Posted July 19, 2013 Hi,Write same subreport query in one datasource & take count of field in that datasource if it zero then hide group band.This is also possibility not a sure about this.Regards,Ajinkya Link to comment Share on other sites More sharing options...
thomas.frommelt Posted July 19, 2013 Author Share Posted July 19, 2013 how can i do this. Can you give me an example? Many thanks Link to comment Share on other sites More sharing options...
ajinkya_c Posted July 20, 2013 Share Posted July 20, 2013 Hi,Creat datasource in main report with same query and parameters which you have in subreport. Take any field of that datasource in your print when expression of group & write condition that print this group if field is not null. This may workarround which i am thinking about your requirement.while doing that main report executes datasource query for group print when expression only, so performance of report degrades.Regards,Ajinkya Link to comment Share on other sites More sharing options...
thomas.frommelt Posted July 22, 2013 Author Share Posted July 22, 2013 Thanks ajinkya! 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