Dynamically Moving Report Objects if SubReport Suppressed
Posted on 2004-04-23
I hope i am asking a question which has a very simple answer, but for all my trying i dont seem able to find it.
I want to put a subreport into the Report Footer alongside an existing chart object (so that the subreport is to the left of the chart). Ideally i would really like to have the subreport in the same section as the chart.
This works well if the subreport contains data - the report looks neatly formatted.
However if the subreport does not contain any data i would like to suppress it and then move the chart object across to cover the entire space of the report footer (else the report has a silly blank space in it).
Does anybody have any ideas on how to achieve this ? - all i want to do is say 'if the subreport is suppressed then resize the chart to cover the bigger space'
Many thanks in advance for your help.