Filters at record level and filters restrictions at cell level

[joseph_gonzales]

Hello Crystal Report friends:

We are aware that we can apply filters globally (record Level). We need to add additional filters(Restrictions) at cell level.How do we apply filters at a cell Level?

Regards,

Joe Gonzales

[Former Member · Accepted solution]

you can not filter cells but you can suppress rows or individual fields

Row

Section expert - > formula opposite suppression add you condition for suppressing rows

Field

Format field -> common formula opposite suppression add you condition for suppressing field

Take care with summaries as data is still there and will be included, if you need summaries use Running Totals and evaluate as required.

Ian

[former_member11696 · Accepted solution]

And along with what Ian said be careful when exporting also, some suppressed fields may export even though you have supressed them, so you are not removing the data, just hiding it. If the user has rights to edit the report they could "unhide" the info.

Depending on the version of CR you are using depends on the output, our export formats tend to change on how they work and what is exported etc.

There are Various DB tools from SAP Enterprise that has the ability to do row level filtering if that is an option for you.

Don