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
This topic has been locked.
2 replies Latest Post - 2012-12-11T08:50:06Z by paddi
Pinned topic opening reports in excel 2010
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-11T08:50:06Z at 2012-12-11T08:50:06Z by paddi
SystemAdmin 110000D4XK15496 Posts
paddi 270005JH6P10 PostsACCEPTED ANSWER
Re: opening reports in excel 20102012-12-11T08:50:06Z in response to SystemAdminhi suresh, thanks for the reply.
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