I have a form with 30 questions.

A customer answer these 30 questions with answers. Some questions can't be answered.

So a couple of fields will be empty.

Now I would like a report or export to excel with only the answers which have an answer.

Is this possible? 

Or how can I fix this problem?

Maby I can use the On Edit --> On load functionallity like:

if (input.field1 = null)

{

      hide field1;

}

The problem is I can't export a form in the on edit mode.

Or is it possible to generate attachment in excel or pdf sent by mail?

The answers of the questions will be used to be put in to a filter in a view with all the records to compare the best result with other records.

If I have multiple questions with no answer it is a lot of work to sort out the questions by hand.

How someone can help me, this is a functionallity I really need.

Greatings,

Erwin Fennema