| MERGE GROUP LEFT AND FORM LETTER STYLE [message #144393] |
Wed, 26 October 2005 06:23  |
MEEENAR
Messages: 72
Registered: May 2005
Location: CHENNAI
|
Member |
|
|
I WANT TO SEND LETTERS TO THE CLIENT..
MY QUERY IS
SELECT DISTINCT c.cli_ent_id ENTID,
E.ENT_ADDRESS_LINE_1 EADD1,
E.ENT_ADDRESS_LINE_2 EADD2,
E.ENT_ADDRESS_LINE_3 EADD3,
E.ENT_ADDRESS_LINE_4 EADD4,
E.ENT_ADDRESS_LINE_5 EADD5,
E.ENT_PHONE_NO_1 EPHO1,
E.ENT_PHONE_NO_2 EPHO2,
E.ENT_ADDRESS_LINE_6 EADD6,
E.ENT_ADDRESS_LINE_7 EADD7,
D.END_EMAIL_ID MAIL
FROM ENTITY_DETAILS D, client_report c, entity_master e
WHERE
c.cli_physical_cntr_flg='N'
AND E.ENT_ID=C.CLI_ENT_ID
AND D.END_ID=E.ENT_ID
IF A CLIENT HAS TWO MAIL ID THEN THERE WILL BE TWO ENTRIES
IN THE ENTITY_DETAILS TABLE
SO IN REPORTS I SELECT STYLE HAS GROUP LEFT
AND I PUT THIS QUERY
AND IN GROUPS I HAVE 2 LEVEL
1 LEVEL
ENTID
2 LEVEL
EADD1
EADD2
EADD3
EADD4
EADD5
EADD6
EADD7
EPHO1
EPHO2
THEN IF I RUN THIS REPORT I GET ALL CLIENT DETAILS AND IF HE HAS 2 MAIL ID THEN THE TWO WILL COME IN THE SAME LINE...
NOW MY PROBLEM IS I WANT TO SEND LETTERS TO THE CLIENT SAYING
THIS IS YOUR MAIL ADDRESS..
IF A CLIENT HAS 2 MAIL IDS THEN THAT 2 MAIL IDS SHOULD MERGE
WITH THAT CLIENT DETAILS RECORD AND I HAVE TO SEND ONLY ONE LETTER TO THAT CLIENT...
TABLE ENTITY MASTER(UNIQUE ENT_ID)
ENT ID
ADDRESS
PHONE
TABLE CLIENT_REPORT
CLI_ENT_ID
STATUS
TABLE ENTITY_DETAILS
END_ID
MAILID
(IF A CLIENT HAS 2 MAILID THEN THERE WILL BE TWO ENTRIES)
PLEASE HELP TO SOLVE THIS PROBLEM...
IT IS VERY VERY URGENT
|
|
|
|
| Re: MERGE GROUP LEFT AND FORM LETTER STYLE [message #144791 is a reply to message #144393] |
Fri, 28 October 2005 05:50  |
MEEENAR
Messages: 72
Registered: May 2005
Location: CHENNAI
|
Member |
|
|
i made 2 groups...
1st group1
ENTID
EADD1
EADD2
EADD3
EADD4
EADD5
EADD6
EADD7
EPHO1
EPHO2
2nd group2
mail
in the first repeating frame I am putting the letter text like this
repeating frame1
&<ENTID>
&<EADD1>
&<EADD2>
&<EADD3>
&<EADD4>
&<EADD5>
&<EADD6>
&<EADD7>
&<EPHO1>
&<EPHO2>
welcome to our concern...
repeating frame1 -source group1
repeating frame 2
&<MAIL>
this your communication id...
repeating frame 2 -source group2
if i proceed like this
first all the address comes and then all the mailid...
can anyone tell me how to proceed with this problem...
|
|
|
|
| Re: MERGE GROUP LEFT AND FORM LETTER STYLE [message #144801 is a reply to message #144791] |
Fri, 28 October 2005 07:18 |
MEEENAR
Messages: 72
Registered: May 2005
Location: CHENNAI
|
Member |
|
|
IAM ATTACHING THE RDF FILE...
NOW IT IS WORKING..
BUT THERE IS ONE PROBLEM ...
WE R MERGING THE MAILID ...
IN THIS RDF ALSO THE MAILID IS MERGED..
IF THERE R 2 MAIL ID THEN ONE APPEARS IN ONE PAGE WITH ALL
THE UNIQUE DATA IN ONE PAGE AND THE OTHER MAILID
APPEARS IN THE SECOND PAGE SEPERATELY...
HOW TO PUT THE MAILID IN A SINGLE TEXT BOX
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
