Report will not return values for a parameter

I have a report where I have created a parameter with several membership types. Have added this criteria to the record selection.
when I run the report I get data for all the membership types except where the type begins with the word Junior
there are several formula in the report, have deleted each one in turn from the report but it still does not work for this group
have checked the group selection expert part, does not seem to be an issue.
Do not know where the problem may lie?
Gordon HughesDirectorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Can you upload the report?
Gordon HughesDirectorAuthor Commented:
Hi Mimcc
report attached
Raghavendra HullurSoftware DeveloperCommented:

Do you have data for the combination of Membership Types starts with Junior and date combination you have included in the record selection?

Is it possible to run the report by commenting the record selection criteria and attach the report saved data?
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

Gordon HughesDirectorAuthor Commented:
Yes there is data which i can get running another report with the same paramenters
Would be a bit concerned about submitting a report with data as it would be against the GDPR
Raghavendra HullurSoftware DeveloperCommented:

If you haven't tried already, can you try commenting the record selection and see you get the data for the combination you selected?, just in case the report logic for this and other reports wary?
Then try commenting date part from record selection and run only for Membership Types which starts with Junior.

Alternatively, you can copy the query generated from report from Database --> Show SQL Query option and run it directly on database using database client to ensure the data is returned for the combination of parameter values selected.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
If there is a lot of data try commenting out the membership type.

YOu could also change the date filter to > 1 Jan 2019

WHat do you enter when trying to get Junior?
Do you select from the list?

How did you populate the list of values for Membership Type?

Gordon HughesDirectorAuthor Commented:
I changes the date to 1/01/2019
Same issue it will not show where Junior x is selected
The list was created in the parameter set up adding the categories from the database
I have another report with the same parameters and that works ok, something is blocking where the selection starts with Junior

Gordon HughesDirectorAuthor Commented:
Think I have found the problem, the date field is currently expiry date and it should be renewal date
Thanks for your support
Gordon HughesDirectorAuthor Commented:
Thanks to you both, put me on the right track
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.