Excluding Fields in Reports

[Fakhruddin Zavery]

Hello,

Is there anyway one can exclude certain fields in a record on reports? You
might have a record having 10 fields but for some records certain fields are
empty and only some contain values.

So is there someway to exclude those fields which are null on a report BUT
still display the fields that have values?

Thanks and Regards

 

[Guest]

One way to have conditional expressions on reports is to base the report off
a query. You can then use statements like IIF(IsNull([FieldName]),etc... or
use criteria to limit your data to only records with values in certain fields.

I am not entirely sure if that is what you were getting at. I hope this
helps.

 

[Fakhruddin Zavery]

Yes I would base it off a Query. But I'm in a situation where I need to send
invoices to clients and only include on the invoice report things that are
relevant only for a particular transaction.

i.e one client may be charged fees x and another not so typically i want to
exclude in a record values that are null and only display the ones that have
a value.

unless there is a better way to approach this scenario.

Thanks and Regards

One way to have conditional expressions on reports is to base the report off
a query. You can then use statements like IIF(IsNull([FieldName]),etc... or
use criteria to limit your data to only records with values in certain fields.

I am not entirely sure if that is what you were getting at. I hope this
helps.

Hello,

Is there anyway one can exclude certain fields in a record on reports? You
might have a record having 10 fields but for some records certain fields are
empty and only some contain values.

So is there someway to exclude those fields which are null on a report BUT
still display the fields that have values?

Thanks and Regards