How to remove empty rows in filtered pdf report.

[Alexey1]

Hi, there

I'm trying to find a way to remove empty rows from my pdf report, I have several projects that use the same data spreadsheet. When I filter the data to create a PDF report, it keeps empty rows from other projects. Can anyone help me with the correct expression that removes all those rows from the report, and keep the report clear and a nice view of the report that shows only filtered data?

P.S. I reckon when you create a built-in CSV file it works perfectly, possible to see to get the expression for the built-in CSV file?

Thanks in advance 🙏

[Joseph_Seddik · Accepted solution]

Sorry to jump in 🙂 

Your SELECT expression is forcing the selection of all rows empty or not. Instead you should write this:

SELECT( Expense[Key],
   AND( ISNOTBLANK([Project Name]), [Project Name]=[_THISROW].[Project Name] )
)

And I echo the words of @dbaum, you really should eliminate the virtual column and put the expression in the template directly.