Report on cells that only contain data

Gary.Celia

Hi,

I have a form that asks many questions on values for ordering stock. There are 20+ columns, which is quite difficult to report on. The user will only tend to use 5-10. Is there away to design a report that only looks at cells that contain data?

Many thanks

Gary

Andrée Starå

Hi @Gary.Celia

I hope you're well and safe!

Yes, in the Report builder, you can select that it only should include the rows with data.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Gary.Celia

Yes perfect, please can you explain further?

Gary.Celia

Excuse me its empty columns that I want to remove from reporting, not empty rows. Apologies.

Andrée Starå

@Gary.Celia

Unfortunately, that's not possible in a Report, but it might be possible by using the Premium App, Dynamic View.

Is that an option?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!