November 7, 2016 at 2:40 am
Hi all,
I have a drill down report with lots of different tables in it. Depending upon the criteria from the top level report only 1 of these tables at any time contains data.
Each table contains an expression for visibility. This works well. However if the table that is used is quite far down I get a lot of empty space above the table. So although the tables are hidden you don't get rid of the space they all take up.
Is there any way of doing this do you think? I have created in this way because the top level grouping report is just one report that shows lots of different business questions and groupings. However each group might point to a drill down containing different data items (Areas of the system) so one report triggers one report
Top level
@Area Demographics
@Question 6
@Cohort Age
Report shows Age Grouping. User Click on an Age For example 6
Drill down Report
@Area Demographics
@Question 6
@Cohort Age
@DataItem 6
Report shows all the Demographics information for 6 year olds
Top level
@Area Sales
@Question 10
@Cohort Area
Report shows Area Grouping. User Click on an Area For example Manchester
Drill down Report
@Area Sales
@Question 10
@Cohort Area
@DataItem Manchester
Report shows all the Sales information for Manchester
Sales Table is beneath Demographics. So I get empty space because Demographics is hidden.
Although it works it does look messy. Id love a few ideas on how to tackle this.
Debbie
November 7, 2016 at 12:30 pm
For me, making the table invisible usually collapses the space it had occupied (using =CountRows() = 0 in the Visibility properties expression for the table). Is there perchance a page break before or after the Demographics table? Or is the Demographics table sitting in a rectangle?
November 8, 2016 at 2:35 am
Thank you for that. For a start your expression is way better that the over complicated one I was using so its already quicker. And I definitely have less white space (I still have some but I think I'm just going to have to let that go)
I thought that it might be the spaces between the tables so I pulled all the tables a lot closed together. I think it helped a little bit.
I don't have any page breaks or rectangles. But its better than it was and faster so thank you:-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply