Reporting error | Community
Skip to main content
Level 3
September 6, 2024
Question

Reporting error

  • 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 

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

1 reply

RandyRoberts
Community Advisor
Community Advisor
September 9, 2024

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?

PHennAuthor
Level 3
September 9, 2024

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.  

 

PHennAuthor
Level 3
September 9, 2024

hmmm…

I tried something very similar and it works as expected.

I filtered on a custom "Buyer" field; a dropdown with eight choices, and also on a plannedStartDate field.

 

I think I would first suggest trying another field to see if it's just that field or not.


Hi, I checked two other fields and the filter worked perfectly.  I submitted a ticket with WF.   Thank you for trying to help.