Multiple rows in a single fetch....

[satyarao]

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...

[brucevde]

Rather than trying to explain what you need to do just use the Report Expert and create a Label report.

Once the report is created, look at the format of the details section to learn how to layout a multi column report.

[satyarao]

Waaaaaaaw....
It is working as i wished.....
I was in hurry.... in generating the report i could n't go thru... Lable report option....

Thank you for your suggestion.... .