We have a report which has more than 80,000 thousand records.the report has two pages, the first one shows the descriptions of the report and the second one has the data. the customer wants all the records to be displayed in a single sheet(more than 80000). we ran the report in excel 2000 single sheet but the first page data is coming like some merged data(the table that has the data looks like merged when compared with original (ran and checked in 2007)).
as 2010 excel displays more than 65,000 in a page, is there a way that we can run the report in excel 2010 or get the data as normal(first page data as normal and not compressed)?
please help with this.
Thanks in advance
paddi 270005JH6P10 Posts
Re: opening reports in excel 20102012-12-11T08:50:06ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
so is there an option to run the report in excel 2010 format from report studio. not like runnig the report in excel 2000 single sheet format and opening in 2010.
thanks in advance