Last post Feb 02, 2011 12:50 PM by jayman9782
Jan 28, 2011 01:27 PM|jayman9782|LINK
I am attempting to concatenate white spaces to a field value in a rdlc report.
I am using the following formula in the TextBox but it does not work as I'd like it to.
=iif(Fields!MenuType.Value = "Root Menu Item", Fields!MenuItemLabel.Value, iif(Fields!MenuType.Value = "Level 1 Open Form" or Fields!MenuType.Value = "Level 1 Parent Menu Item", space(3) & Fields!MenuItemLabel.Value, Space(5) & Fields!MenuItemLabel.Value))
I have a feeling it's because it generates HTML, but I can not figure out any other way to do this. I have also attempted to simply enter an empty string (" " & field) as well as chr(10) (empty character), but these were also failures.
Also, I tested the comparisons, by manually entering fake data if the condition is met and this worked fine, so it is not the comparisons.
Any help would be appreciated!
Thanks in Advance,
Feb 02, 2011 12:50 PM|jayman9782|LINK
I fought with this for hours and finally decided to go with a workaround. I created a host of subreports and sub-subreports to create the "indent" effect. If you would like to see a solution, contact me and I'd be happy to walk you through it.
Thanks anyway, Jay