Crystal Reports Probably very basic, but...

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Probably very basic, but...

Author	Message
barrymac1 Newbie Joined: 17 Aug 2009 Location: United States Online Status: Offline Posts: 10	Topic: Probably very basic, but... Posted: 26 Jan 2011 at 5:34am
	I want to create a simple "and" statement. I only want to see students who took "class a" AND "class b", not OR (which is what i get when i use the "is one of" option in the select expert). Who can help me??
	IP Logged

Keikoku Senior Member Joined: 01 Dec 2010 Online Status: Offline Posts: 386	Posted: 26 Jan 2011 at 6:20am
	In the select expert, you can choose one of the pre-defined options, or you may choose to write your own custom formula and use it. In your formula, you can write just that. {table.field} AND {table.otherfield} This will display all records that satisfy the condition. I am not sure which version you use, but you can do this in the select expert window as well as the formula editor.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 26 Jan 2011 at 7:46am
	i think the issue is that Class A and Class B are on differnt rows. If you need a crystal only solution, group on student create two 'flag formulas' flag_class_a if classfield="A" then 1 flag_class_b if classfield="B" then 1 Sum both of these at the student group level in the select expert use the group select option and use your criteria here SUM(flag_class_a,student)>0 and SUM(flag_class_b,student)>0 Group selection criteria occurs after the report is built so all students will appear in the group tree but only students that meet your criteria will appear in the report
	IP Logged

barrymac1 Newbie Joined: 17 Aug 2009 Location: United States Online Status: Offline Posts: 10	Posted: 03 Feb 2011 at 9:08am
	thanks, but this doesn't work. First there is no "pre-defined option" for creating an AND statement in Crystal 11. They all behave as "OR" statements, pulling any data that matches the selection. As far as the AND example you provide, that doens't work either, as "table_field" is the same for both values i want pull ("class.course_code"). I'll give the provided below a try, if I can figure out exactly what he's talking about.
	IP Logged

barrymac1 Newbie Joined: 17 Aug 2009 Location: United States Online Status: Offline Posts: 10	Posted: 03 Feb 2011 at 9:09am
	thanks, i'll give this a try, although i'm not fully versed on formulas yet.
	IP Logged

Keikoku Senior Member Joined: 01 Dec 2010 Online Status: Offline Posts: 386	Posted: 03 Feb 2011 at 10:07am
	*Originally posted by barrymac1* As far as the AND example you provide, that doens't work either, as "table_field" is the same for both values i want pull ("class.course_code"). 1: I am assuming if a student is in class A and in class B, then two records will appear for that student, where the only difference is the value of class.course_code. The flag example should work because if you were to group the records by student, then all of the records for a particular group will be the classes that the student is enrolled in. Flag A will = 1 if the student has taken class A. And flag B will = 1 if the student has taken class B. Your group filter will show all groups where both these flags are > 1 for the particular group (ie: student) Edited by Keikoku - 03 Feb 2011 at 10:08am
	IP Logged

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum