Welcome, Guest. Please Login.
05/02/24 at 12:07:40
News:
Home Help Search Login


Pages: 1
Send Topic Print
Crystal Report to Export BOMs, notes, remarks (Read 1375 times)
Marianne
Browser
*




Posts: 36
Gender: female
Crystal Report to Export BOMs, notes, remarks
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
Back to top
 
 
Email   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Crystal Report to Export BOMs, notes, remarks
Reply #1 - 10/14/08 at 10:33:34
 
Check on 'Select Distinct records' under the Database menu.
 
Hope it helps, I dont use CR.
 
 Tongue
 
Kelloggs
 
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Marianne
Browser
*




Posts: 36
Gender: female
Re: Crystal Report to Export BOMs, notes, remarks
Reply #2 - 10/14/08 at 10:47:46
 
Funny but that option is grayed out on my screen.
Back to top
 
 
Email   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Crystal Report to Export BOMs, notes, remarks
Reply #3 - 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
 
 
 
 
 Wink
 
Kelloggs
Back to top
 
« Last Edit: 10/14/08 at 15:19:09 by Kelloggs »  

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Pages: 1
Send Topic Print