Moving table/chart position dinamically
Hi all,
I need some info:
Is it possible to modify the table/chart position dinamically?
For instance: a report with 2 table/chart, based on value parameters I would like to make Not visible a table/chart and move the other visible table/chart in the same position where the other table/chart is not visible?
If yes, how can do it?
Thanks
Any help will be very appreciated
May 30th, 2011 4:36am
Dynamic position is not possible in SSRS.
Workaround:
Place the Table/Chart one by one. Apply visibility condition accordingly for the whole Table/Chart. Based on condition the table/chart can be visible. SSRS automatically ignore space if any data region is hidden. i.e you will not see any space of hiden regions(Table/Chart).
This I tested with SSRS 2008 R2.
Hope this helps..Regards, Senthil
Free Windows Admin Tool Kit Click here and download it now
May 30th, 2011 5:33am
SSRS 2005,
but it looks like that some gaps are kept. to be checked.
Any contribution will be appreciated
May 30th, 2011 5:53am
hi Senthil is exactly right
just want to add that you can actively use expressions in Chart and
Table properties or any another object to move or place
based on parameter or DataSet fields Value you can integrate to
Position expression
and dynamically move your object.
Please mark this as answer if it helps.
Microsoft Certified Trainer
Microsoft Certified Professional Developer
BizTalk blog: http://www.EnterpriseApplicationsDevelopment.com/
Free Windows Admin Tool Kit Click here and download it now
May 30th, 2011 6:03am
Hi,
Tble/chart position's value is a static value, so there is no Position expression for us to set.
However here I still would recommend you to submit a feedback to Microsoft Connect at this link
at this link https://connect.microsoft.com/SQLServer/Feedback
This connect site is a connection point between you and Microsoft. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider to add this feature in the following release.
Regards,
Challen Fu
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
May 31st, 2011 1:24am