Hide rows without information

[Juanjoge]

In the report that I am generating and that has divisions according to this structure
Input/Output
    Category

There are categories that have no data but the report shows them, how should be the instruction to hide these categories?

This  is the code who generate the report

<<Start:ORDERBY(FILTER("Notas",AND([Entrada/Salida]=[_THISROW-2].[Entrada/Salida],[Tipo_servicio]=[_THISROW-1].[Tipo_servicio],[Fecha_entrada]>=[FromDate],[Fecha_entrada]<=[ToDate])),[NumNota],TRUE)>><<[NumNota]>>

Thanks for your help

[WillowMobileSys]

---

@Juanjoge wrote:

There are categories that have no data but the report shows them, how should be the instruction to hide these categories?

---

What does "no data" mean?  Certain columns in the row don't have values? 

If you needed to point to the rows that needed to be eliminated, how would you identify them?

[Juanjoge]

Hello, @WillowMobileSys , thanks to see my post and try to help me 😊

No data is , for example, there were no dry cleaning outputs and the report shows me that table without information, I think, I'm not sure, is that one of the ways to identify them is because there is no invoice associated with this subcategory (dry cleaning) and category (outputs).

[WillowMobileSys]

I don't know you data.  Let's look at it this way.  Your template is using the table "Notas".  When you look at the rows in that table, can to tell which ones need to be skipped?  If so, how are you identifying them?  What data/column ( e.g. an empty colun\mn) in that row tells you it needs to be skipped?  

[Juanjoge]

If you look at the data (below) you will see that there is no way to identify this because there was simply no operation during the day and therefore no record.

[WillowMobileSys]

AH!  there is another expression in the template that is choosing the Categories.  It is in that expression where you want to remove the Categories if there is no data rows to report on.  

the easiest way is to remove the categories you don't need to report on right up front.  I would do this with the COUNT() function.  Something like this:

SELECT(Categories[Category ID] ,  
       COUNT(SELECT(Notas[Notas ID], 
                   [Category] = [Category ID])
       ) > 0
)

I guessed at the names for your Category table and category column names.  Replace them with proper names from your app.

[Juanjoge]

Thank you very much, I will try it and get back to you with the result.