Microsoft Dynamics AX (Archived)

Can I set the size of a rectangle dynamically in SSRS Reports

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi all,

How can I set the size of a rectangle dynamically in SSRS Reports?

Thanks,

Dhanya

*This post is locked for comments

All responses (12)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Can I set the size of a rectangle dynamically in SSRS Reports

Thanks Lee,issue solved
Verified answer

dolee 11,279 on at

Like (1)

Report

RE: Can I set the size of a rectangle dynamically in SSRS Reports

One trick that you can play around with (to see if you can get what you want) is to add additional header row(s). You can do things like following:

- Merge all the cells and use it as title

- Merge all the cells and set all of them to have no borders. Then it'll just look like normal spacing.

- Merge all cells, then put in a rectangle control. After that you can add multiple textbox controls into that space and line them up anyway you like
Community Member Microsoft Employee on at

Like (0)

Report

RE: Can I set the size of a rectangle dynamically in SSRS Reports

Sorry for the late reply Lee, As you mention the screenshot of my requirement is attached. Please help me

Thanks ,

Dhanya
dolee 11,279 on at

Like (1)

Report

RE: Can I set the size of a rectangle dynamically in SSRS Reports

So far what I mentioned is that a rectangle control would *passively* react to auto-grow of its containing controls (textbox or table).

However, it seems like that's not what you need and I am not sure the requirement.

Maybe you can show some screeshots on what you like to achieve?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Can I set the size of a rectangle dynamically in SSRS Reports

Thanks Lee, What I mean in "table size" means the visibility of the columns in the table depends on the parameters .so want to increase the rectangle size(contains the report title text box) according to the table columns.
dolee 11,279 on at

Like (1)

Report

RE: Can I set the size of a rectangle dynamically in SSRS Reports

Hi Dhanya,

For a textbox in SSRS, there is the "CanGrow" option. When it's set to true, the textbox will expand vertically if necessary.

If the textbox above is put into a rectangle (where the textbox's Parent property is set to the rectangle's name), then the rectangle should grow with the textbox.

I am not sure what do you mean by "table size" increase, but a table should works the same with respect to how a rectangle (which contains the table) would react when the table grows.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Can I set the size of a rectangle dynamically in SSRS Reports

Sorry Jaleel,but it's not working for mine issue
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Can I set the size of a rectangle dynamically in SSRS Reports

Text properties > General > Check Allow Height to increase.

if you need more information you can contact me on skype : erp.jaleel
Community Member Microsoft Employee on at

Like (0)

Report

RE: Can I set the size of a rectangle dynamically in SSRS Reports

Hi,

Thanks Jaleel, I am newer to SSRS, don't know which is option for that?

Please Reply
Community Member Microsoft Employee on at

Like (0)

Report

RE: Can I set the size of a rectangle dynamically in SSRS Reports

Hi,

Yes it can grow, select the option in the text box properties