locked
Report hide empty rows RRS feed

  • Question

  • I am extending the quote report.  I have added an extra row in the details report for the product.  The row will display the discount amount for each product.  Obviously not all products have discount - this leave my report will with a lot of blank empty rows, which is wasting space.

    How can I hide the whole row so that a complete blank row will not be shown?

     

    Please vote if you find my post useful. Add me on Skype @ christo.skype1

    Wednesday, April 30, 2014 9:50 AM

All replies

  • The report row has a Visibility property, which can be set to an expression so you can conditionally hide a row based on the report data. Note that if the expression evaluates to true, the row is hidden

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Wednesday, April 30, 2014 4:12 PM
    Moderator
  • What is the correct query to check if a field contains data?  If the field (text) does not contain data the row must be hidden

    Please vote if you find my post useful. Add me on Skype @ christo.skype1

    Monday, May 5, 2014 11:05 AM