Reporting error

Forum|Forum|1 year ago
September 6, 2024
1 reply
1229 views

Hi, does anyone have any insight into this scenario?

I'm trying to create a project report using a dropdown field in the brief. There are 10 options or so in the drop down and the user can only pick one which would make it seem simple to run a report based on the option selected, but it isn't. If I want the report to show Option A information, I can't. It randomly shows other options. For instance Option A, Option D, and Option C might appear. We have edited the field multiple times over the years, so I'm wondering if there is some type of legacy information in the background which is influencing the data I receive.

Any thoughts?

Thank you

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

RandyRoberts

Community Advisor

Can you post the filters you're trying to use for the report? as well as some of the dropdown option names?

Also when you say "Option A information" are you wanting to just display the name?

P

PHennAuthor

Level 3

Hello, yes, I want the report to filter a specific set of information. It is a very simple filter.

The report should only show data for projects that have been identified as Surety. But that isn't the case - The report is showing a variety of other segments. There are nine other options in the drop down.

Thank you for your assistance.

P

PHennAuthor

Level 3

Has your problematic field EVER been a multi-select, even if it's single-select now? That makes me wonder if there isn't historical data from an old config of the field where multiple options could be selected.

Good morning, yes, I believe it has been a multi-select field in the past. I was wondering if that was the cause of the problem. Do you know if there is anyway to resolve it while keeping the information that is correct? Thank you

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded