Hello, I am trying to generate reports from ...

(Yogesh laddha) #1

Hello,

I am trying to generate reports from one of the tables in my app. Everything is going well and the reports are formatted as expected.

The only issue I have is that, there are certain fields which are blank sometimes and I have applied showif conditions that if blank, they are hidden. Its working well in the app,

but they still show up in the report. Is there any way I can hide fields which are blank in the reports?

(Michael Avenilov) #2

Is the report in excel? if so, maybe try and create a template for the Report with built in formula (=iferror).

I use it myself

(Praveen Seshadri (AppSheet)) #3

This has been asked by a few others too. At the moment, there isn’t a convenient <> templating syntax.

Could you please add this to https://www.appsheet.com/feature-requests

(Yogesh laddha) #4

@praveen Sure. I will add a feature request.

It would be very convenient to generate well-formatted reports if we can have this feature.

Thanks.

(Aleksi Alkio) #5

@Yogesh_laddha There is a workaround for this… not very elegant, but doable :slight_smile: When the “VAT” is not blank, the CONCATENATE will generate a line enter. If it’s blank, it doesn’t add a new row. As Praveen mentioned, we should have a easier way.

Sub Total: <<[SUB_TOTAL]>><<IFS(ISNOTBLANK([VAT]),CONCATENATE("

","VAT%: ",[VAT]))>>