Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Report Builder layout situation. Have a textbox object 'Page n of m' positioned on the rhs (right hand side) of the Page Header.
When the report is run the 'Page n of m' object gets printed on the lhs.
Debugging and it looks like only the Image object stays in place from page 1 on. Textbox, line and rectangle gets shifted on subsequent pages to the lhs after page one.
Create blank report, A4 portrait. Add the simple objects to the rhs of the page header. Add a simple query to force multiple pages.
All objects in the Page Header are playing nicely and printing where they are positioned. So that is the sanity check and back to the real report for debugging and why ...
Back to simple debug report after finding that the issue is to do with the Hidden property when an expression is used.
Regardless of vertical positioning of a say Textbox with Hidden property set to expression of =IIf(Globals!PageNumber <> 1, True, False) for example. Any other objects on the page header get shunted the horizontal width size of the hidden object.
CanShrink, CanGrow have no effect.
So the Hidden property acts differently when set to True as to when set via expresssion. Hidden value of True setting has no effect on horizontal space whereas when set as an expression and the result of the expression is True the horizontal space the hidden object takes up gets released so to speak and any other objects on the same layout object (header, footer or body) gets moved to the left by the hidden object horizontal width size amount.
Looks like a bug with Hidden property when expression outcome is True.
Workaround is to place a hidden object on the horizontal plane to the lhs of the object(s) you do not want to move. With Hidden property set to True.
Solved! Go to Solution.
Add tag Tips and Tricks ... and accepted my own solution :}
Add tag Tips and Tricks ... and accepted my own solution :}
Hi @garythomannCoGC ,
Thank you for sharing ! This is very helpful to me !
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.