suppress the display of a txt box when null

Hot Topic

Creating report based on parent-child dimension
Cross Package Configuration Files
Making changes to SSIS packages
MDX based report parameters misbehave when inter-dependent
Bug (?) in SQL2005 x64 SP1 CTP
Is Ad hoc reporting compatible with Web Applications
SSIS job cannot find file....
Design and Performance Question
Calculate Median Value
RS2000 dataset doubt

SQL Server

Executing a Stored Procedure in a loop
Wildcard Searches
SSIS Error Output -- how is it supposed to work?
KPI value expressions
Join problem
Email reports based on a condition
Package variables in case of an Exception
Download a report from Reporting Services.
Cart data row
SQL query

suppress the display of a txt box when null

I have a text box in a list, which i only want to display if it is not null.
How can i do this in reporting services.

thx
la

Answer this question

suppress the display of a txt box when null

  • Boris C

    You must put in the value the expression:
    = IIF(CSTR(Fields!EvaluatedField)="", "", "The Title")

    I hope it helps you

  • Joshua Belden

    Select the list item where your data objects are places, go to the properties and write for example No Data in the NoRows properties. That's all

  • Dan-el

    Yes, you can conditionally set the visibility on both the row and / or group based on the value.



  • Bilbob

    Thank you

    Is there a way to stop the entire line from displaying on the report if the field is null

    thx
  • suppress the display of a txt box when null
Answer this question