Matrix help with blank field

  • 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

  • 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?

  • 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 2 (of 2 total)

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