Joined: 24 May 2012
Online Status: Offline
Posts: 2
Topic: price list problem Posted: 24 May 2012 at 1:18pm
Help needed, i'm fairly new to crystal reports.Im currently doing a pricelist report.All parts are grouped by a machine field and the report works well.Im stuck now where i have a part that can be in multiple machines, this part number (a seperate field) therefore needs to be replicated under multiple machine headers.
Can anyone help?
If this is a stupid question i'll apologise in advance.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 25 May 2012 at 3:48am
you might try linking to the same table on the other field so you get duplicates (kindof)...i'm not sure if cr will let you bring in the same table twice and do a self join, that might do it.
of course a stored proc can easily duplicate the data.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 29 May 2012 at 8:02am
select *
from table as t1
join table as t2
on t1.partnumber = t2.partnumber
where t1.rowid != t2.rowid
the where clause is so that the exact same line doesn't display twice. Obviously rowid is just for the example, but this should duplicate the data as needed.
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