Print Page | Close Window

My data disappear with Select Expert

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21090
Printed Date: 30 Apr 2024 at 2:00am


Topic: My data disappear with Select Expert
Posted By: kbrezovich
Subject: My data disappear with Select Expert
Date Posted: 01 Oct 2014 at 10:20pm
Hi All,

I need a bit of help with one of my reports. Any advice is appreciated.

I'm designing a report running on a bank account report listing the current balances. This is linked to a static table to establish if the account currency is the functional currency of a given company or not. So I have a flag to say "Y" or "N". Which is working just fine for all items.

In the select expert I choose to only display all items with flag "N". However after this not all of the items are displayed even though they had "N" flag before.

Thanks


Replies:
Posted By: hilfy
Date Posted: 02 Oct 2014 at 4:52am
What are the other criteria in your selection formula? Do you have an Left Outer or Right Outer joins between the tables in your report. Will every record returned by the query in the report have a non-null flag value?

-Dell

-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: kbrezovich
Date Posted: 02 Oct 2014 at 6:07am
Thanks.
All my tables are joined with left outer link. And this N flag is the only selection criteria.
What I don't understand is that if I don't have any selection criteria than all my records are displayed some with flag N some with Y.
If in Select expert I set this formula field to be N only then only the items with N flag are displayed but not all of them. It seems a bit random to me.

Thank you!

Posted By: hilfy
Date Posted: 02 Oct 2014 at 6:11am
Try changing the formula in the Select Expert to something like this:

IsNull({flag field}) or {flag field} = 'N'

-Dell

-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: DBlank
Date Posted: 02 Oct 2014 at 3:05pm
NULL is the more likely answer but ...
keep in mind if the joins are not set to enforced and you had not used any fields from that table (or daisy chained table) the enforcement of that join will take place at the time you use the field. that can change your record set too.

Posted By: kbrezovich
Date Posted: 08 Oct 2014 at 10:09pm
Thank you all for the suggestions. First results are promising. I will test this soon properly and let you know how it went! Thanks again for your help!


Print Page | Close Window