| Prevent Duplicate records in Report [message #161240] |
Thu, 02 March 2006 15:37  |
sikorsky05
Messages: 40
Registered: October 2005
|
Member |
|
|
I have the following 2 records...
PART_EIPN ---------|NOMEN--|FMC | PDT | PDT_DESC---------|LOG_NO
70107-28400-043 | BIFILAR | 16 | A23 | BIFILAR ASSEMBLY | 18
70107-28400-043 | BIFILAR | 16 | A23 | BIFILAR ASSEMBLY | 23
How can I have report only print one record and have under log_no print 18,23
Is there anyway I can prevent the 2nd record from print but still display the 2 log_no (18,23)
|
|
|
|
|
|
| Re: Prevent Duplicate records in Report [message #161345 is a reply to message #161240] |
Fri, 03 March 2006 06:49  |
sikorsky05
Messages: 40
Registered: October 2005
|
Member |
|
|
Thanks that worked... But now have another problem...
Before when I had the queries the report printer FMC in descending order... for no repeating log_no.
9,41,47,55
But now when I did what you recomended it prints
55,9,41,47,55
FMC is being pulled from query #1
Here are the queries I am using in my data model
Query # 1
Select f.model,f.part_eipn,f.nomen,e.FMC,s.PDT,p.PDT_DESC,e.log_no,rownum
from GENFRAC_r_part_EIpn f, event_log e,event_status s,r_pdt p
where s.pdt = :pdt
and s.pdt(+) = p.PDT_CODE
and p.model = 'PBLH60'
and f.PART_EIPN = e.EIPN
and e.log_no = s.log_no
and f.model = 'PBLH60'
and e.model = 'PBLH60'
and s.model = 'PBLH60'
&ROW
order by fmc
PDT1 & PDT_DESC are grouped above
Log_no is grouped below query #1 .
Query #2
Select unique(f.fmc),f.model,f.S_DESC FAIL_MODE_DESC
from fail_mode f where f.model = :model
order by f.fmc
Query #3
Select fmc, model, s_desc CA_SHORT_DESC from fm_ca
where model = :model
Query # 4
Select * from fm_ca_doc
where model = :model
order by doc_seq
Datalinks
FMC & Model link all 4 queries together...
Thanks for the help
Also y does pulling log_no below do this...you learn more if know the logic behind it ... Then you never forget it .
|
|
|
|
| Re: Prevent Duplicate records in Report [message #161349 is a reply to message #161240] |
Fri, 03 March 2006 07:08 |
sikorsky05
Messages: 40
Registered: October 2005
|
Member |
|
|
Nevermind the last question about sorting ... I removed all sorts on the 1st main query group and it worked...
Now log no print 18
23
is there any way I can make it print 18,23 on one line..
the whole Idean behind this is if the FMC has 5+ Log_no
it will take up alot of space up print on seperate lines
Thanks again for all the help
[Updated on: Fri, 03 March 2006 07:23] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
