SSRS: Report label position dynamic

Question

I have a report which displays customer address in multiple labels.

My customers use windowed envelopes for mailing. I need the address labels position to be configurable.

Something like, I'll have a database table which stores the Top/Left position of each label per customer. Based on this table, I need to position the address labels on my report.

I thought, it is doable by expressions, but Location property doesn't provides ability to set an expression and make the label's top and left dynamic.

Anybody, any ideas, on how to achieve this?

Answer 1

As you mentioned, you cannot set an expression for location property. I want to do this before but it seems that there is no solution for this work.

Answer 2

No solution, as it is not supported!!!

From MS online community support...

"As far as I know, the position of the textbox in the report is static not dynamic, so it will not shift to left."

Reference: http://forums.asp.net/t/1433297.aspx

Answer 3

Sorry for the duplicate post

I had the same problem as you did. I got around the problem by using an old HTML trick. It involves using a transparent.gif in an image. You put your image (linked to the gif), then put your label on top. Using a parameter, you can toggle which item to appear by setting an expression in the hidden property for both controls.