How make height of Report header dynamic?
Hi all,
How to make the height of the report header dynamic is SSRS? The height of report header changes dynamically when I preview the report, but height of the report header does not grow in printing preview mode.
Thanks.
May 28th, 2012 1:10pm
Hi There
If You are putting any text inside your header and you would like that text dynamically grow. Please put a text box inside your Header and set its
cangrow property to true.
If you have any question please let me know.
Many Thanks
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful
Free Windows Admin Tool Kit Click here and download it now
May 28th, 2012 4:58pm
Hi Bharat,
From your description, the page header can grow dynamically to accommodate the contents when previewing the report. This indicates that the CanGrow properties of the textboxes in the page header are set to True already. Actually, the default value of
this property is True. In hard page break rendering formats like PDF, the height of page header/footer is fixed. Besides, it not supported to set the height of the page header/footer based on an expression currently. This is by design.
Personally, I recommend you that submit this suggestion at
https://connect.microsoft.com/SQLServer/. If the suggestion mentioned by customers for many times, the product team may consider to add the feature in the next SQL Server version. Your feedback is valuable for us to improve our products and increase the
level of service provided.
Thanks for your understanding.
Regards,
Mike Yin
June 4th, 2012 7:17am


