Skip to Content
0

SAP Crystal Reports Selection Criteria

May 26, 2017 at 08:00 PM

37

avatar image

I'm a long-time user of Crystal reports and have NEVER had this problem in the past. I'm using Crystal Reports 2011. When I created a report of vendor payments for a specific date range, I get all of the data that I expect. When I attempt to add selection criteria to report a vendor that "starts with" the first five letters of the vendor name, I get no results. Does anyone have a solution?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Brian Dong May 26, 2017 at 11:24 PM
0

Hi Susan,

What does your Selection formula look like?

Are you using the Left function like:

Left ({table.VendorName}, 5) = "Vendo"; 

Also, Crystal is case-sensitive so make sure the spelling is always the same otherwise put the lowercase function before the Left.

Good luck,

Brian

Share
10 |10000 characters needed characters left characters exceeded
Susan Jakusz May 30, 2017 at 06:47 PM
0

I was not using a formula like yours, but I redeveloped the report WITHOUT using the wizard to place my fields on the report and didn't have any problems with the very basic selection criteria that I had defined. However, I do see the value in using a formula that you defined as it ensures that Crystal is reading the field as desired.

I used a formula that looks like this and it is working, after rewriting the report without using the wizard (very odd).

{apvenfil.VendorName} in [{?Vendor Name}] and
{apdetfil.ApDetailVchOrCheckDate} > {?Date Entered}

Share
10 |10000 characters needed characters left characters exceeded
Susan Jakusz May 30, 2017 at 06:53 PM
0

Actually, Brian, your formula is much more reliable. When I rebuilt the report, I also changed the selection criteria to allow the user to choose a vendor name from the drop down list of vendors. THAT'S the reason why the report is working, had nothing to do with the way that the report was built.

Thanks so much for your help.

Sue

Share
10 |10000 characters needed characters left characters exceeded