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

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?

0 4 391
4 REPLIES 4

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

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

@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.

@Yogesh_laddha There is a workaround for thisโ€ฆ not very elegant, but doable 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]))>>

Top Labels in this Space