We help IT Professionals succeed at work.

Report will not return values for a parameter

102 Views
Last Modified: 2019-01-14
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?
Comment
Watch Question

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Can you upload the report?
Gordon HughesDirector

Author

Commented:
Hi Mimcc
report attached
Membership-Renewal.rpt
Raghavendra HullurSoftware Developer
CERTIFIED EXPERT

Commented:
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?
Gordon HughesDirector

Author

Commented:
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
Software Developer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
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 HughesDirector

Author

Commented:
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
Gordon HughesDirector

Author

Commented:
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 HughesDirector

Author

Commented:
Thanks to you both, put me on the right track
Gordon
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.