Avatar of Gordon Hughes
Gordon Hughes
Flag for United Kingdom of Great Britain and Northern Ireland asked on

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?
Crystal ReportsMicrosoft Word

Avatar of undefined
Last Comment
Gordon Hughes

8/22/2022 - Mon
Mike McCracken

Can you upload the report?
Gordon Hughes

ASKER
Hi Mimcc
report attached
Membership-Renewal.rpt
Raghavendra Hullur

Hi,

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?
Your help has saved me hundreds of hours of internet surfing.
fblack61
Gordon Hughes

ASKER
Hi
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
Gordon
ASKER CERTIFIED SOLUTION
Raghavendra Hullur

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Mike McCracken

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?

mlmcc
Gordon Hughes

ASKER
Hi
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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Gordon Hughes

ASKER
Hi
Think I have found the problem, the date field is currently expiry date and it should be renewal date
Thanks for your support
Gordon
Gordon Hughes

ASKER
Thanks to you both, put me on the right track
Gordon