Select Expert not showing data to choose
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22999
Printed Date: 05 May 2024 at 3:47pm
Topic: Select Expert not showing data to choose
Posted By: kmclaugh
Subject: Select Expert not showing data to choose
Date Posted: 03 Mar 2022 at 6:44am
Please help! This is so simple but something is not working right. Crystal 2020, one table as source. 3 fields selected....client, matter, transaction date.
We have many clients and then matters within that client. I've selected one client - it works. Selected date >= 1/1/2022 - it works. I try to select one matter # that is clearly showing in the report but that matter # is not available in the list of available values when I try to filter for just that matter. If I manually enter the matter # and refresh the report an empty report is returned. Why is the data not available to select when it is clearly there?
|
Replies:
Posted By: kevlray
Date Posted: 04 Mar 2022 at 5:10am
I would suspect that there is something amiss with how the matter # is stored (leading, trailing invisible characters?). Without seeing the data (and type) and what is entered. It is hard to say for sure.
|
|