SSRS - Text Boxes Shifting Expressions RRS feed

  • Question

  • Hello All,

    I do have a SSRS Report ,with different Data sets and is fetching data Correctly and working fine .

    On the TOP of the Report have 4 different Location Text Boxes and expressions written in it.

    T1    T2     T3     T4

    Requirement  :

    Now the requirement is that ....if any one the Location is Disabled . That concerned Text Box will disable. it will not be visible and there will be Re-Sizing (Location Change) in the text Boxes.

    Giving below test Cases

    Case 1 : if location Textbox T3 is disabled in Database. then the rest TextBoxes will display like this below :

    E.g;    T1  T2  T4

    Case 2:

    If Location Text Box T2 is disabled ., below will be the Display of Text Boxes

    E.g;   T1 T3 T4

    Case 3

    if location Textbox T1 is disabled , below will be the disaply

     E.g;  T2 T3 T4

    Case 4 : if location TextBox T4 is disabled .., below will be display

     E.g; T1 T2 T3

    In every above cases .., if any disabled Text Box , the Rest Visible Text Boxes are Shifting available empty place

    I tried to do this .., but not finding any way .

    Wednesday, August 14, 2019 9:17 AM

All replies

  • Hi

    you Need  in each of the TextBox the .visible with the Expression you like to see visible=true/false

    personal i would use one field and use the condition to Show the data from Field 01 to 04

    otherwise if you place field 01 to field 04 on your report and the visible is set to false the next field will not 100% move to the same place (that is by design)

    | Please Mark This As Answer if it solved your issue |
    | Please Vote This As Helpful if it helps to solve your issue |
    | Disclaimer:
     This posting is provided with no warranties and confers no rights. |
    | N 48° 8' 39.8419" E 11° 36' 1.3359" |


    Wednesday, August 14, 2019 9:37 AM
  • I already did that

    But the Text Boxes are not Shifting . i need to shift the text boxes


    T1 T2 T4

    T2 T3 T4

    Like this

    Wednesday, August 14, 2019 9:39 AM
  • see my note

    this is not possible.. Unfortunately


    Wednesday, August 14, 2019 9:41 AM
  • i am trying to do this impossible thing ....

    even i inserted the TABLIX on top  and pasted created the textboxes and made the column  expression

    i am trying . Hope anyone knows this or give any idea

    Wednesday, August 14, 2019 10:15 AM
  • i wish someone has a idea

    the only way i know is use a new field with the data from field 1 to 4 and 

    use the Expression the data you like on the conditions. 


    Wednesday, August 14, 2019 10:21 AM
  • right that is also fie .

    but in my case if any location textbox is disabled i need to shift rest textboxes it .

    Wednesday, August 14, 2019 10:23 AM
  • Whys are you using a text bos, use a Matrix with horizontal Pivot function, that will do the job.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, August 14, 2019 10:28 AM
  • Yes Olaf,

    I am near to my Resolution of this Case .

    I tried using Tablix and insert 4 Text Boxes in that and in the tablix column properties wrote the Visibility Expression and used a Empty DS for this .

    it is getting me the expected result that i want

    Thanks OLAF and KLAUS

    • Proposed as answer by Mitarai Queen Thursday, August 15, 2019 1:31 AM
    Wednesday, August 14, 2019 10:31 AM
  • You need to create textboxes one over the another and need to set the visibility property .

    For 1st Location: create 4Textboxes T1,T2,T3,T4.Place the textboxes over each other.
    Set the visibility property.. If T1 is available then show T1 only.

    For 2st Location: create 3Textboxes
    Repeat same for T2,T3,T4

    For 3rd Location: create 2Textboxes
    Repeat same for T3,T4

    For 4th Location: create 1Textbox
    Repeat same for T4

    If T1 is available then show T1 in first place and hide other textboxes in first place.
    If T2 is not available then check for T2......If not T3....

    Use the IIF expression to achieve it

    Vishal Jharwade
    Wednesday, August 14, 2019 11:03 AM
  • Hi Rakesh Dhar

    Seems you have solved your issue, if possible you could mark the appreciated reply or you solution as answer .

    So other members in this forum could get benefit from it .

    Thanks for your support and understanding .

    Best Regards,

    Eric Liu

    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    Thursday, August 15, 2019 1:35 AM