Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: 2 reports 2 lists Post Reply Post New Topic
Author Message
Jelle Bijl
Newbie
Newbie


Joined: 07 Jul 2011
Online Status: Offline
Posts: 5
Quote Jelle Bijl Replybullet Topic: 2 reports 2 lists
    Posted: 14 Jul 2011 at 2:40am
Hi all,
 
At the moment i'm trying to fix this problem.
 
I have created 2 lists, both on different reports. One list contains all our parts with actual stock (LIST X). The other list contains all our parts which are sold last year. (List Y)
 
Now what I want to accomplish is the following: I want a list (LIST Z) which show LIST X - LIST Y.
 
For example:
 
LIST X
Part A
Part B
Part C
Part D
 
LIST Y
(group) Part A
         (DETAIL) Part A - date sold
         (DETAIL) Part A - date sold
         (DETAIL) Part A - date sold
         (DETAIL) Part A - date sold
(group) Part C
         (DETAIL) Part C - date sold
         (DETAIL) Part C - date sold
         (DETAIL) Part C - date sold
         (DETAIL) Part C - date sold
 
LIST Z
Part B
Part D
 
There is only one catch. LIST Y is a list with groups. Now I'm trying to do something with subreport but I have not found a solution yet.
 
Does somebody have an idea?
 
Thanks.
 
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 14 Jul 2011 at 2:45am
do you want list x to subtract list y?
or do you want both in one report?
sharona
IP IP Logged
Jelle Bijl
Newbie
Newbie


Joined: 07 Jul 2011
Online Status: Offline
Posts: 5
Quote Jelle Bijl Replybullet Posted: 14 Jul 2011 at 2:56am
HI,
 
No not really subtract.
And yes I would like them both in one report. (nut neccasary)
 
But the most important thing is that LIST Z shows me all parts which LIST X shows. EXCEPT the parts that LIST Y generates!
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 14 Jul 2011 at 3:01am

what is your datasource a spreadsheet or tables, view, sp?

sharona
IP IP Logged
Jelle Bijl
Newbie
Newbie


Joined: 07 Jul 2011
Online Status: Offline
Posts: 5
Quote Jelle Bijl Replybullet Posted: 14 Jul 2011 at 3:06am
I'm using a SQL database. Working with Baan IV software.
 
Not sure what you mean with view and sp?
 
However I am trying to do something called Vlookup in Excel.
 
Hope you understand what i mean Embarrassed
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 14 Jul 2011 at 3:25am
you contact to tables the?
sharona
IP IP Logged
Jelle Bijl
Newbie
Newbie


Joined: 07 Jul 2011
Online Status: Offline
Posts: 5
Quote Jelle Bijl Replybullet Posted: 14 Jul 2011 at 3:31am
yes i make use of tables. but what do you mean.
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 14 Jul 2011 at 7:24am
it is easier to help you build what you need.
so the data comes from the same table i presume
the best thing to do is  create a sub report containing the actual stock (sub reports tend to run slower so the one with the least amount of data you should use)
in the main report create a group by part id
then place your sub report in the group
make sure you group your sub by part id as well
and link your sub to the main by the part id
sharona
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.