Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Compare two subreports Post Reply Post New Topic
Author Message
Ivyand
Newbie
Newbie
Avatar

Joined: 04 Sep 2008
Location: United States
Online Status: Offline
Posts: 3
Quote Ivyand Replybullet Topic: Compare two subreports
     Posted: 05 Sep 2008 at 9:37am
Hello again,
 
How do i compare the data in one subreport to the data in another subreport?
 
For instance I have a list of dates in sub1 and a list of dates in sub2 how do I say look at sub1 and compare the dates to sub2 and tell me which dates are not in sub 2.
 
Thanks,
 
Scorr
 
IP IP Logged
Savan
Senior Member
Senior Member
Avatar

Joined: 14 Dec 2007
Location: India
Online Status: Offline
Posts: 162
Quote Savan Replybullet Posted: 08 Sep 2008 at 2:57am
create two different global variables for e.g, vara, varb  and pass vara in one sub report, pass varb in second sub report. keep on adding the dates to these variables with a speratior.
for e.g in sub report 1
vara := vara&totext(date)&";"
subreport 2
varb := varb&totext(date)&";"
 
now in the report footer of the main report  u can store all the dates in two different arrays from the two variables and compare the dates.
 
The process is bit tricky, but i m sure this may work out for you.
Thanks
Savan
IP IP Logged
Printable version 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