excel formatting problem

[drallpradeep]

I prepared a report in rtf which is working fine but I call in Ms-Excel format, Its hide the row and column. It display in column like a then d then J etc..... same in row like 1 then 5 etc. Formatting is not good. I checked there are no columns are overlapping.I have only field which should be dispaly in a to e column.

Please suggest me how set these fields.

 

Regards,

Pradeep

 

[lucianc]

The elements in your report design do not seem to be aligned.  See this FAQ for some information on designing XLS friendly reports.

Regards,

Lucian

[drallpradeep]

I gone through the topic "Making HTML, XLS or CSV friendly reports" and set my report. I need your help for the following points.

1.  how to set "Minimizing the number of rows and columns in the grid oriented formats (minimizing the number of "cuts").
". what is means of "cuts".

2.   Very typical job to adjust one by one field but row and columns create the problems. Excel reports display the row no. 5,7,9 and hide the 4,6,8.... I need to display all rows, same problem is in column.

when the end user copy this excel file and transfer the data in another database then blank fields create problem.

3. how to display the grid instead of plain report.

I am attaching herewith my jrxml and out snaps for your kind reference.

Regards,

pradeep

 

 

[andfedotov]

Here you are!

 

I'm too kind today :)

 

Btw, remove these people's banking account details... I wouldn't be excited to know that my account information was disclosed somewhere on the forum...