How to lock controls in Report design page in SSRS 2005
Hi, I m designing the report in cheque format. while entering the text (Eg. Name/Address/Cheque no) of more length in text box control, then contents break to next line and the format is changed. I m using various controls (Textbox,Table,Image) to create cheque report. Here design is changing based on length of the text we give as input. Pl. suggest how to lock the controls even the length of text changed. Thanks, Bala
July 24th, 2012 10:32am

For the text box in question, right click and select Testbox Properties. Look for properties "Can Grow" and "Can Shrink". Set them accordingly.Todd C - MSCTS SQL Server 2005, MCITP BI Dev 2008 Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
July 24th, 2012 12:59pm

Hi Bala, In Reporting Services, text boxes are a fixed size. You can set options that let the text box expand or shrink based on its contents. These options correspond to the CanGrow or CanShrink properties in the Properties pane. The default setting for CanGrow property is True, so the size of the textbox can change by the length of the content. In your scenario, Todds suggestion is exactly right, you can set the CanGrow property of the textbox to False to avoid this issue. If you have any questions, please feel free to ask. Regards, Charlie Liao
July 24th, 2012 11:43pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics