March 12, 2014 at 12:27 pm
I have a gauge with a label containing the value from a column in the dataset the gauge is based upon. Sometimes there won't be a value for a particular row. I'm passing the name of a person in from another report. This works correctly but displays "Text" if there isn't a value for that person. It displays the numeric value if there is.
In other words, the person exists in the main report I'm calling the gauge report from but may not have a row in the individual dataset of a gauge. The gauge report has several gauges, at least one of which will have a score for that person. Many times the person will have a score in each gauge's own dataset. I just need to know if there's a way to change the default display of "Text" when there isn't a row for a given gauge. It's a cosmetic issue. It makes the report confusing to a user. I wouldn't mind either 1)hiding the value or 2) changing the nword "Text" to something else.
How can I control what's displayed instead of "text" in the label? Thanks.
I'm using Visual Studio and deploying to SQL Server 2012.
March 13, 2014 at 9:06 am
Figured it out. I just needed to put this bit of VB code in the label property text. Details: Right click on gauge label, select properties, click Fx button to right of text box or just enter this in text box directly: =IIf(IsNothing(Fields!CompositeScore.Value)," N/A", Fields!CompositeScore.Value)
Where YourVariable if the actual value I want to display on the gauge if there's a row for the person whose gauge I'm displaying.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply