I am embarking on my first SSRS report, and am noting the many differences between Business Intelligence Studio and Infomaker.
Something I am missing is a way to "slide up" text fields the way I could in IM, e.g. having address lines slide up if a second address line is blank.
Is there a way to do this in BI studio?
Thanks.
If your working with a table you can use expression to set the visibility of the cells/rows based on a value return from your data set. If you want i could send you a report.
Unknown said: If your working with a table you can use expression to set the visibility of the cells/rows based on a value return from your data set. If you want i could send you a report.
Thanks for your reply. At the moment, I am working with textboxes rather than a table due to formatting requirements. Is that my problem? I've set the visibility expression formula for the textbox to:
=iif(Len(First(Fields!street2.Value, "lp_dev_full_bio2_add1"))<1,True,False)
... and it's hard to see if that does anything, since the boxes it would affect are empty anyway, but it certainly isn't causing the textboxes below to slide up. A formula similar to the above seems to be working for hiding phone number masking that would otherwise appear where there is no phone number, but maybe "sliding" would require a table.
I am not sure that you can programatically change the position of a textbox. What you could do is have a second set of textboxes that are hidden behind. Then if there is no value you could hide some of the fields and show the others to give the appearance that they went up.
Another option thought I have not played with it to much is to create a Custom Report Item that does what you want. HEre are two useful links on creating them.
http://msdn.microsoft.com/en-us/magazine/cc188686.aspx
http://msdn.microsoft.com/en-us/library/ms345219(SQL.90).aspx
Unknown said: I am not sure that you can programatically change the position of a textbox.
I am not sure that you can programatically change the position of a textbox.
I was afraid of that. I was thinking like IM, where fields arranged next to each other can slide up or left based on their own or each others' contents. I'll miss that!
Unknown said: What you could do is have a second set of textboxes that are hidden behind. Then if there is no value you could hide some of the fields and show the others to give the appearance that they went up.
What you could do is have a second set of textboxes that are hidden behind. Then if there is no value you could hide some of the fields and show the others to give the appearance that they went up.
Hmm. I've done that sort of thing with IM, and may try it here, too.
Unknown said: Another option thought I have not played with it to much is to create a Custom Report Item that does what you want.
Another option thought I have not played with it to much is to create a Custom Report Item that does what you want.
A lot of interesting stuff there. Thanks for the links!