|
-
Jul 4th, 2003, 06:13 AM
#1
Thread Starter
Member
Multiple rows in a single fetch....
Hi,
I am working with Crystal Reports 8.5.... I am having 'Address' table in Ms-Access database. the table consists the fields... namely.... 1) Name 2) HNo 3) Street 4) Area 5) City
I have to print the records parallelly.... i mean side-by-side. if any field is null then next field should be printed... instead of empty(gap).
Example data:
---------------
Name--------------HNo------------Street-----------Area----------City
--------------------------------------------------------------------------------
RaviKumar----------------------MGRoad-----------Paradise----SEC'BAD
Siva----------------A-54-----------------------------Ameerpet-----HYD
Surya--------------5-10----------------------------EluruRoad------VJA
Kishore-------------------------MainRoad---------------------------KKD
out put in the CR should be as follows.....
RaviKumar````````````Siva
MGRoad,`````````````A-54,
Paradise,`````````````Ameerpet,
SEC'BAD`````````````HYD
Surya```````````````Kishore
5-10,```````````````MainRoad,
EluruRoad,```````````KKD,
VJA
like the above.... pattern.... the labels should be printed.....
in A4 size paper .... i want to print.... 8 labels in 2 columns....
Thanks in advance...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|