Report Filter Selector Pulling In Wrong Field

Home Forum Reporting Report Filter Selector Pulling In Wrong Field

This topic contains 4 replies, has 0 voices, and was last updated by  Anonymous 9 years, 4 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #196

    Anonymous

    I have a simple report in which I want to filter based on one field in the data source form. I’ve selected the correct field in the filter selector properties, but it is clearly pulling in the wrong thing. It gives me a drop down that has some labels from some radio button options that are in a different section of the form.

    #4544

    ijobling
    Participant

    Are you saying that the filter is not showing you the options to filter as you expect? if so, review the object names you are using on the actual form to check that the field used in the filter selector the correct one. could for instance you inadvertently have duplicate field names

    #4548

    Anonymous

    No – I am saying that I am selecting the field I want. I know it is the correct field, I’d used it before in this same report & it did what I expected previously. But now, although I select that field, the drop down gives me something completely not what it should be.

    #4550

    ijobling
    Participant

    have a look at ‘debug’ (under the FORM menu item) where you can preview the form but also see what actions/events are running as the report runs. Could there be other actions on the form that are influencing what you are trying to see here.

    Also.. see if adding in a new page to the current report, and then setting up the same filter input object also presents this situation. if it is all OK there, then delete the object you are having the problems with and add in again.

    if that doesn’t help, can you contact us directly at support@perfectforms.com with your account details and we can look to review the server action logs to see if that helps identify what is going on here

    #4681

    Anonymous

    I had this problem previously. At some point I happened on the issue (for me) – I had republished the form I was reporting from.

    If you republish the report, you need to go into the datasources in the report properties pane, click to “edit” whatever sources are there that were republished, and click on “refresh” in the edit window.

    That solved my problem. Hopefully it solves yours!

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.