Topic
  • 2 replies
  • Latest Post - ‏2012-12-11T08:50:06Z by paddi
paddi
paddi
10 Posts

Pinned topic opening reports in excel 2010

‏2012-12-07T10:20:58Z |
Hi,

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
Updated on 2012-12-11T08:50:06Z at 2012-12-11T08:50:06Z by paddi
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: opening reports in excel 2010

    ‏2012-12-07T16:14:47Z  
    Hi,
    Excel 2010 supports for 1,048,576 rows. I hope for you this much enough. Try to run in Excel 2010.

    thanks,
    Suresh.
  • paddi
    paddi
    10 Posts

    Re: opening reports in excel 2010

    ‏2012-12-11T08:50:06Z  
    Hi,
    Excel 2010 supports for 1,048,576 rows. I hope for you this much enough. Try to run in Excel 2010.

    thanks,
    Suresh.
    hi 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