... below.
The MDX Expression
This is to be applied to the "Fill" expression of the textbox with the field name changed for each cell you apply this to; note that in the following example, "Data_Retrieval" ...
...
IIF your result row count, if it's zero, just display blank, else, do the rest of the query. Blank out the textbox basically (execution time is kinda irrelevant when you get 0 matches)
We went with ...
... of trying to find a solution, I would definitely recommend seeing if you can't check at the database level first. I will in future.
Debug Method
Fallback to debug methods; create a textbox that ...
... (request reference) number.
The Report
We start off with our detailed report page which lists all the details of a student. There is a textbox linked to an action which will open another report ...
... and a little confusing tweak to make it all work! Where "Equipment" is the name of the dataset.
Bring up the tablix properties (or the textbox you want to hide)
Select "Visibility" in the left ...
... properties instead of getting the expression to return it exactly (there seem to be issues with this - error textbox1[0]...).
You will need this expression to set the font color of days that are in ...
...
Select "Size and Position..."
Copy to clipboard the exact height value
Right-click on a faulty heading textbox
Select "Size and Position..."
Paste ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.