Merge tablix design create empty spaces in AX pdf but not in Visual Studio pdf

(0) Share

Report

Posted on by Community Member

Hi all, I have a report which have 2 tablix merge in the design, example :

-Tablix 1 has parent group of ProdID

- Tablix 2 is merge under tablix 1

When the report is populated, if the record is more than 1 page, the whole records in tablix 2 will move to page 2 leaving empty spaces in page 1. In order to avoid that, I have set keep together option as false in both tablix and also for the row in tablix 2.

For the group ProdID, I have set page break- between each instance of group.

When I run preview from Visual Studio and export as pdf, the result is just what i want.

It has no empty spaces and records in tablix2 are populated in page 1 and continue in page 2, but when i deployed it in AX

and export as pdf, it leave empty spaces in page 1 and all records in tablix 2 goes into page 2.

How come the pdf design is different from Visual Studio and AX version?

I have restart multiple times all the services, deploy report using power script commands as well as restart the server physically and no luck so far.

I don't know whether this is because the layout in AX hasn't updated to the newest version or there are some missing steps when i design the report in visual studio.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

zeeshan.shaikh 683 on at

Like (0)

Report
Copy link

Link copied!

Dear Ahau,

Can you please tell the following settings of your report:

1. Your report width , left margin and right margin.

2. Your both tablix body sizes.

You need to make sure that your tablix1 and tablix1 body width must be less than or equal to the (Report width - left margin - right margin)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

hi Ali,

my report has 8.27in width

and left = 0.3in, right = 0.2in

my merge tablix body size has width 7.45in

which is still less than report width - left margin - right margin.

Strangely when I exported it to pdf from Visual Studio preview page, it doesn't have empty spaces and all the records in tablix2 are populated in page 1 and continue to page 2...

while if I export pdf from AX print page it does leave empty spaces and all records from tablix 2 moved to page 2 leaving a lot of spaces in page 1

Was this reply helpful? Yes No
Suggested answer

Hajish 460 on at

Like (0)

Report
Copy link

Link copied!

Drag and drop a rectagle and set keep together is tick.

Place the both tablix in rectangle.

I hope this will help you to slove your problem.

Was this reply helpful? Yes No
Verified answer

zeeshan.shaikh 683 on at

Like (0)

Report
Copy link

Link copied!

Dear Ahau,

Why you have used an empty details group row? if you want one row space I would say make that row out of details group. It should not be detailed row. Please also check if your report property of ConsumeContainerWhitespace is set to true.

Let me know if above two suggestion works for you.

Thanks

Was this reply helpful? Yes No