Matrix help with blank field

  • Ysa

    Mr or Mrs. 500

    Points: 522

    Hello there 

    I need help with this matrix, I am trying to align the row as you can see I have a blank filed, How I can avoid this I was using the NOTHING but it didnt work, I going to have some scenarios where the expenses are 15 lines and the revenue used will be just one. Please help

  • logitestus

    SSCrazy

    Points: 2817

    If I understand your description correctly, you are trying to show a drill-through report.  Or are you attempting to do this matrix with 2 datasets?

  • meichmann

    SSCommitted

    Points: 1899

    You can try setting the visibility of the row itself.

    In the details group properties, select visibility, then select "Show or Hide based on an expression".  In the value field, type this:
    =Iif(IsNothing(Fields!JournalNumber.Value), True, False)

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply