Can I create a Grid Report with filter or a condition to display only certain submissions?

  • Profile Image
    afcpool
    Asked on March 31, 2015 at 06:35 PM

    I didn't ask this question, but these are the same words I would have used to ask the one that I have, which your answer does not address:

    Can I create a report which only includes submissions that have a certain field completed? That is, I know I can create a report limiting the columns I to the ones I care about for a certain purpose, but I get all submissions reflected. Obviously, once I download to excel, I can hide or delete all lines with blank data, but I cannot do that with a Grid Report. Is there some way for conditional inclusions?

  • Profile Image
    Carina
    Answered on March 31, 2015 at 06:45 PM

     

    Unfortunately it is not possible to hide empty fields on grid reports, but you can select the fields while creating the report:

    But please let us know more details of your needs so we can try to find a solution that suits you.

    Let us know if we can assist you further.   

  • Profile Image
    afcpool
    Answered on March 31, 2015 at 11:30 PM

    Thanks; I had not been optimistic.

    We have a single form gathering lots of information. However, respondents don't need to complete all the fields, only some of the fields need to be seen by different members of our organization. So, when I created a grid report on our registration form just for Swim Lessons, I just would like to see submissions where someone clicked on swim lessons registrations. 

    I had been hoping that you might have a function akin to what you do for customizing notifications, so that I could get a report of all submissions that met a certain condition.

  • Profile Image
    ashwin_d
    Answered on April 01, 2015 at 09:13 AM

    Hello afcpool,

    You seems to be looking for a customized report with a filter feature. Unfortunately, it is currently not possible to create a report with filter.

    Let me send a feature request to our back end team. We will get back to you as soon as we have any update from them.

    Thank you!

  • Profile Image
    NHS24-LPE
    Answered on May 16, 2017 at 10:53 AM

    Could the filtering options that are available via the Visual Report builder be made available for Grid Reports? I have a need to be able to provide data that is filtered in particular ways to different people and so would create a filtered version of the report for each of them. 

    The Visual Reports builder is almost totally useless and so I cannot use that to meet my needs. The grid reports are excellent but I cannot show all of the records to all of the people.

    Thanks,

    Stuart

  • Profile Image
    ashwin_d
    Answered on May 16, 2017 at 11:42 AM

    Hello Stuart,

    This is a very old thread. I have moved your question to a new thread so that we can address it separately. You will be answered in the following thread:  https://www.jotform.com/answers/1146002

    Thank you!