1. First create the data source in your Datasets folder.
In my case, my dataset is called dsStatusDDL because I'm pulling a status field from a SharePoint list.First create the data source in your Datasets folder.
Sol Web Solutions Blog is aimed to help, inform, educate and enable our site visitors.
I had a customer request to hide a row conditionally, but when the report rendered in the browser the hidden row still took up spacing on the report.
I found this post thanks to Frank v.d. Laar:
Try to set the Hidden property of the Static Row Group under the Details Group, in this case the whole row will disappear instead of the content of the textboxes.
If you are using Report Builder, you need to switch to Advanced Mode (make sure that the Properties and the Grouping windows are displayed, go to the upper right side of the Grouping window and press the black triangle), click on the second "Static" item under the "(Details)" group and you can set the Hidden property on the Properties window.
I had a requirement to add some spacing after a prefix of a textbox to align with a row below it and make the report more visually appealing. I tried the space() function within my expression, and that didn't work.
Here's what I did to resolve our scenario:
1. Left Double click the textbox that will hold this value/expression
2. Right click the textbox area and select "Create Placeholder" from the flyout menu option
3. In the "Placeholder Properties" pop-up modal, make sure to select
"HTML - Interpret HTML tags as styles" when in the "General" section
4. When creating the expression, I used the following for my padding:
& " " , "") & Fields!comment.Value
In my scenario, if the type was "Issues", then I needed to put:
a prefix of "Issue:" + spacing + my comment field