Help with a expression to filter a table in report

[daniel_sanchez]

Hi, I've been practicing making bots and working with expressions for my clients, but at the moment, I'm honestly unsure why I can't get it to work.

I have an app that's shared with several clients. This app manages merchandise receipts, and each customer should only see their own merchandise. However, even though I've enabled the option to download reports, one client asked me to automatically send them a report. So, I quickly created a bot and used the following expression within the report's first column:

<<Start: SELECT(Reporte Semanal[No. Control],AND([Cliente] =”Industria Vidriera de Coahuila
”,[Estatus Final]<> "IMPORTADA"))>><<[No. Control]>>

The table name is "Reporte Semanal," the Key Row is "No. Control," and the client's name is "Industria Vidriera de Coahuila." They need the report to show all materials except those labeled "Imported."

The problem is that the bot runs fine, but the file it generates is empty.

I'm lost, because if there is material from this company.

thank you!

[lynchk21]

Just checking, do you have the <<End>> expression at the end of your report?

[daniel_sanchez]

Yes, and the bot runs, but the report is empty.

[lynchk21 · Accepted solution]

Maybe try making a slice with your SELECT(Reporte Semanal[No. Control],AND([Cliente] =”Industria Vidriera de Coahuila
”,[Estatus Final]<> "IMPORTADA")) condition and then double check it is returning the data you expect. If it does, try using the slice in place of Reporte Semanal.

[daniel_sanchez]

When I started having problems with the formula, I did think about making a slide, but since I have other applications in which I have a bot with similar expressions, it seemed strange to me that this one doesn't work. I didn't want to go the easy way hehe

[daniel_sanchez]

Yes well, I ended up doing that, I think it would have saved me a lot of headaches haha, thank you!

[AleksiAlkio]

If the data is blank and Bot generates the PDF, it usually means the list is just blank. That you can easily test if you remove both of your conditions and generate the PDF. It should bring all the data from every client.

By any chance is the [Client] column a Ref and you are trying to find rows with the label value and then it doesn't find any?

[daniel_sanchez]

Yes, the table has 141 lines with information for 3 differentt Customers, and yes when run the bot as a test I saw that the reports arrived blank, removed the conditions and so the report began to contain all the data.

the [Cliente] Column dos't ref 

thank you for you time

[AleksiAlkio]

What is the base type of your Enum column? Is it a Ref?

[daniel_sanchez]

no, is text ...😅

[AleksiAlkio]

When the Bot works and reads rows properly, then the reason are your conditions. Add them back one by one, and then you can see which one is not correct.

[daniel_sanchez]

yeah, finally I gave up, and created a slice with the formula to filter only the material of my customer, and then eliminate in the bot formula, only I programmed to run the days that my client needs. 🙄 thank you!

[AleksiAlkio]

Okay 🙂