Export and customize crystal report in Excel

Question

I had a problem in that when exporting a report to an excel list, there are many spaces and empty cells between the data, as well as merging cells.

Is there a way to export the report, and each field will be in a cell or to control this export, suppose my report looks like this:

No  Trans_No 
1    123
2    333

In my excel sheet I would like

A    B
No  Trans_No 
1    123
2    333

but currently it shows a merge of cells and spaces, so instead of Trans_No will be in CELL B, it is in D.

So, is there a way to control exports?

Answer 1

mohs, welcome to stackoverflow.

Crystal Reports Excel . .rpt .xls Crystal . :

• Crystal ?

  . Excel ( Crystal), Data- > Import External Data​​strong > .
  B. Crystal CSV. Excel , CSV .

• Crystal Report .

  . , , .
  B. , ​​ .
  C. ? , , , .
  D. , .

Answer 2

, Excel:

• > (Excel 2010)
• a > ""

Crystal Reports, CSV , Excel. .

Answer 3

Crystal Excel :

(1) CSV CSV Excel.

, , , - :

No   Trans_No   1   123
No   Trans_No   2   333

, , CR XI - , , , , ( ), Excel.

(2) Sequentially format all fields to the same minimum size (usually two grid widths), with columns aligned by binding the left edge of the fields to the recommendations.

This gives a conclusion that is almost unreadable in the standard report viewer, but which should align correctly in Excel.