Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

problem with report if I export into Excel file

Status
Not open for further replies.

konda1234

Programmer
Oct 28, 2004
5
US
Hi,

I have a report some thing like

recno name address city
1 xx yy zz

aa bb cc
dd ee ff
2 ss sdf sdf
ch 33 er
er tu idf
...............

If I export the above report to excel the records are not coming in correct formate i.e in the excel file looks like

1 xx yy zz
aa bb cc
dd ee ff
2 ss sdf sdf
ch 33 er
er tu idf

I want excel file some thing like this

1 xx yy zz
aa bb cc
dd ee ff
2 ss sdf sdf
ch 33 er
er tu idf

I want the excel file some thing like from report.
Please can any one help me how can design a report so that excel file looks in that format.

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top