Crystal Reports Report Returning Partial Data

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Report Returning Partial Data

<< Prev Page of 2

Author	Message
djandlo Newbie Joined: 16 Jun 2011 Location: United States Online Status: Offline Posts: 20	Posted: 16 Jun 2011 at 9:03am
	is there something I could use in place of like?
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 16 Jun 2011 at 9:11am
	Until you know why the rows are being excluded it would like give you the same results. there is startswith {Subscriptions.PRODUCT_CODE} startswith "CHAPT" instr() instr({Subscriptions.PRODUCT_CODE},"CHAPT",1)>0 so all of your records from Subscriptions that have "Chapt*" also have the matching NAME row with member type in GEN,AC,AF,CO,FE,RES and paid_thru=12/31/2010 and a status="A"? Edited by DBlank - 16 Jun 2011 at 9:12am
	IP Logged

djandlo Newbie Joined: 16 Jun 2011 Location: United States Online Status: Offline Posts: 20	Posted: 16 Jun 2011 at 9:20am
	Yes, they all do have a member type and the chapter product. That's where I started to make sure that the records where setup correctly.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 16 Jun 2011 at 9:24am
	this is just weird then. try a cut and paste of this..... {Name.MEMBER_TYPE} in ["GEN", "AC", "AF", "CO", "FE", "RES"] and {Name.PAID_THRU}= Date(2010,12,31) and {Name.STATUS} = "A" and ({Subscriptions.PRODUCT_CODE} in ['GEN2011', 'AF2011', 'CO2011', 'FE2011', 'RES2011'] OR {Subscriptions.PRODUCT_CODE} startswith "CHAPT")
	IP Logged

djandlo Newbie Joined: 16 Jun 2011 Location: United States Online Status: Offline Posts: 20	Posted: 16 Jun 2011 at 9:32am
	Yes, definately weird... The results are the same - it's just those 3 states that are still coming up short! I do appreciate your help.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 16 Jun 2011 at 9:52am
	you said the amounts are there but the codes are not, correct? are you doing conditional suppression on any field or rows?
	IP Logged

djandlo Newbie Joined: 16 Jun 2011 Location: United States Online Status: Offline Posts: 20	Posted: 16 Jun 2011 at 10:13am
	DBlank you are OUTSTANDING!!!!!!!!!! I checked in the Detail Section & sure enough there was the suppression statement ({Subscriptions.PRODUCT_CODE}IN ['CHAPT/DC', 'CHAPT/AZ','CHAPT/VT'] I really appreciate you hanging in there! This makes you the Superstar of the day! Thanks for all your help... This Buds for you! Edited by djandlo - 16 Jun 2011 at 10:22am
	IP Logged

<< Prev Page of 2

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