Hi All,
I am trying to export report to Excel with ALV Excel option on status bar, it works fine for 3 months data with 80 columns in the report. But when I run the report for one year data then report displays data fine in R/3 but when I download to Excel it's empty. The eroor is Dataset can't be processed by Excel.
Then I tried with option Download ->Local file->spreadsheet. which doesn't save headers in it. And colums coming in two lines But user wants all columns with header if i do with this option it's not pulling headers.
Please let me know if anybody had the same issue and came up with solution. That would be really great!
Thank you.