drugul Posted February 13, 2018 Share Posted February 13, 2018 Hi,I've got report with 3 subreports at 3 bands, at 1 band subreport is with label.If there is no data at all 3 subreports, label still is displaying text. Label shouldn't be displayed if there is no data at all 3 subreports and only once if one or more subreports have data.How can I do this, 'print when expression' ?Thanks Link to comment Share on other sites More sharing options...
byron.ullauri Posted February 14, 2018 Share Posted February 14, 2018 For each subreport, add a return value (id go with a boolean) that tells the master report if it had data (Maybe check if a field value is null).Go into the 'print when expression' of each:A.) band if the subreport is the only component there (by hiding the band you get rid of empty space)B.) subreport if there are other components in that band (the subreport will not be visible but will still occupy space)The 'print when expression' for the two subreports without the label should be their corresponding return value.The 'print when expression' for the subreports with the label should be an OR statement that includes all three return values. (ex. REPORTA_VISIBLE || REPORTB_VISIBLE || REPORTC_VISIBLEP.S"... and only once if one or more subreports have data." Not sure why it would print more than once unless you have it in a repeating group or detail band, in which case you should add the last OR part to the label itself and include the built-in COUNT variable to check if its == 1 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