ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> Crystal Report to Export BOMs, notes, remarks
http://www.istechforum.com/YaBB.pl?num=1224003202

Message started by Marianne on 10/14/08 at 09:53:22

Title: Crystal Report to Export BOMs, notes, remarks
Post by Marianne on 10/14/08 at 09:53:22

I've created a Crystal Report pulling from BKBMMSTR, BKBMNOTE, and BKBMREMK. The problem I'm having is that the report prints with duplicates lines of the components associated with each Parent. Each of these lines prints each remark associated with that component regardless of which Parent it belongs to. So I get
Parent A, Component 123, Remarks - measure wire,
Parent A, Component 123, Remarks - mesure wire
Parent A, Component 123, Remarks - Splice one end
Parent A, Component 123, Remarks - Splice one end
Parent A, Component 123, Remarks - Splice one end

When in this case, only the 1st entry has to do with Parent A.

Any suggestions?

Thanks,

Marianne

Title: Re: Crystal Report to Export BOMs, notes, remarks
Post by Kelloggs on 10/14/08 at 10:33:34

Check on 'Select Distinct records' under the Database menu.

Hope it helps, I dont use CR.

:P

Kelloggs

Title: Re: Crystal Report to Export BOMs, notes, remarks
Post by Marianne on 10/14/08 at 10:47:46

Funny but that option is grayed out on my screen.

Title: Re: Crystal Report to Export BOMs, notes, remarks
Post by Kelloggs on 10/14/08 at 11:10:16

Each componet has a "Remark", and each componet's parent has a "Note". If that is the case, this query should work fine.

Now, this is a matter of "grouping".
On your report if you group them as mention about you should see a componet, its parent and its parent note
below you should see all the remarks for each "componet". right?

SELECT DISTINCT
BKBMMSTR.BKBM_PARENT,
BKBMMSTR.BKBM_COMPONENT,
BKBMMSTR.BKBM_REFERENCE,
BKBMNOTE.BKBM_NT_NOTE_1,
BKBMREMK.BKBM_RM_REMARK_1
FROM BKBMREMK RIGHT JOIN BKBMMSTR LEFT JOIN BKBMNOTE ON BKBMMSTR.BKBM_PARENT = BKBMNOTE.BKBM_NT_PARENT
ON BKBMREMK.BKBM_RM_COMP = BKBMMSTR.BKBM_COMPONENT
AND BKBMREMK.BKBM_RM_PARENT = BKBMMSTR.BKBM_PARENT

;)

Kelloggs