Hi,
I am trying to only show the entity members with PDF files available in a dataview. I've tried all available "IS____" functions but none is working.
Is there a function that can help me filter out members without available file?
Okay so you seem to be saying there that as long as they've picked one or more of the Org values you've indicated that the data view will display, does that need to be the case even if the selected Org doesn't have a PDF file then?
I've amended mine to something similar
However if I delete the PDF from line 050 the whole data view will no longer be displayed.
If you need the data view to display if the user has selected one of those Orgs, even if the selected Org doesn't have a PDF attached, then you'll probably need to find a different way, probably something in a screen trigger maybe setting some sort of visibility flag.
Hi Efraim, can you show me your layout? I just tested it with a PDF cube in a simple layout and as long as I untick Show All Rows mine only shows the rows with attached PDFs.
@Robert Barkaway I am thinking I need the Show All to be enabled since I have another data block that dictates the visibility of the dataview. If the Show All is disabled that datablock doesn't show as well so my dynamic visibility won't work.
Okay, then wouldn't successfully filtering on the PDF block have the same effect? If you show me your layout I'll see if I can suggest a solution.
I think you might be right - it will be the same effect. Layout is below. Thanks!
