I got one requirement like report output should be in excel sheet.
After data model creation and designing layout, i tried to generate output in excel using batch file.
There I have given destype=file desformat=SPREADSHEET, but in excel sheet output format is not coming properly, as some null fields are coming, fields are getting enlarged .
I have given vertical elasticity and as well as horizontal elasticity as fixed in repeating frame.
Could you please suggest me what to do in this case, is there any more setting needs to be done from my side.
I am using Report builder 10.1.2.2.0.