RDLC report hidden tablix blank space

Chant · 2013-08-13

I'm working on a RDLC report in NAV2013. This report has about 6 tablixes, for each tablix the user can choose in the request page which tablixes should be visible.
To hide/show the tablixes:
I have put each tablix in another tablix with only 1column/1row and a rectangle and used row visibility

For the page breaks:
Between each tablix I made another (very small) tablix with a rectangle with PageBreak-property set to 'End'. I hide this tablix depending on the options chosen in the request page.
There is almost no space in the report between all the tablixes.

When the user selects to see everything, the report looks normal, so there is no unwanted blank space.
page 1: Subject1
page 2: Subject2
page 3: Subject3
...

The problem is that when the user skips one or more tablixes, I get unwanted blank space on the first page. For example the user wants to see Subject 4, 5 en 6 the report will be like this:
page 1: bit of empty space (not as much as the whole tablix, but still bigger than the very small tablix to control the pagebreak) before Subject 4
page 2: Subject 5 (no empty space)
page 3: Subject 6 (no empty space)

If the user skips more tablixes, there will be more blank space.

Any ideas?

clausl · 2013-08-14

Could you share the Report.RDLC, Dataset.xml and AboutThisReport.xls, then I will have a look at your problem.

I explain here how to create the Report.RDLC and Dataset.xml:
http://mibuso.com/blogs/clausl/2012/06/24/offline-preview-and-debug-reports-in-microsoft-dynamics-nav-2013/

/Claus Lundstrøm

clausl · 2013-08-14

OK, I found the problem and learn somthing new, thanks ;-)

When doing visibilty on Tablix, the tablix still uses the space allocated to the tablix in the report.
If you change to doing row visibilty instead your information will be truely hidden.

I did a small sample report which illustrate the issue. As you can see here I have added 4 tablixes to this report.
1st tablix each row is set be not visible.
2nd tablix is visible
3rd tablix is set to be not visible(Just like your report)
4th tablix is visible

Here is how it looks in Visual Studio:

And here is how it looks in Preview. Notice that 3rd tablix still uses the space allocated to it, eventhough I have set it to not visible. And of course also notice that 1st tablix is not showing at all.

/Claus Lundstrøm

Chant · 2013-08-19

Well that helped a lot, thank you!

ssi · 2013-10-04

I'm missing something: Setting a row to hidden still shows empty space. I created a simple report. The second detail row is set to Hidden = true. I would expect the "Print 2" line to be directly underneath "Print". See attachments.

clausl · 2013-10-04

Works perfect when I do your simple example, could you share your Report.rdlc and Dataset.xml?

/Claus Lundstrøm

ssi · 2013-10-08

Claus - It appears I am only able to attach images. I can e-mail you the report object as text or you can e-mail me what you did.

Jut · 2013-11-16

Hi Claus,

I have the same problem here - even Setting row visibility to false does not help.

Any idea what else I can try?

Regards,
Jut

Jut · 2013-11-17

if someone is interested in my solution: Claus found out that I had to create a tablix around my grouped table and to set row visibility on the outside table

Jut · 2013-11-17

duplicate post...

geordie · 2013-11-21

Jut wrote:

if someone is interested in my solution: Claus found out that I had to create a tablix around my grouped table and to set row visibility on the outside table

Hi, I'm facing the same problem but I didn't understand exactly this solution...could you please give some more details?

Thanks

Edit: I found out that, for detail lines, setting visibiliy on corresponing row group (enabled switching to advanced mode) works fine.

Howdy, Stranger!

Quick Links

Categories

RDLC report hidden tablix blank space

Answers