problems exporting to excel

I have 2 levels of drill down. The first level does expand/collapse. The
second level, the details, do not get exported unless that section was
already open in the report. I am using Excel XP.
Any ideas?
Thanks.Normally, even the drill down isn´t checked the data will be exported to
excel. perhpas you disabled the function in excel for drilling down into the
data (on the left side there are + and - signs if you have something to
drill down)
Unfortunately my Excel on my machine and is asking for the corp.CD which is
sure don´t have, because I am on the move, so I can´t give you the exact
menu item to search for, but I gues google and the help file form Excel
should be your friend.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"scraejtp" <scraejtp@.discussions.microsoft.com> schrieb im Newsbeitrag
news:10F795EE-7C5C-4A80-9492-607216270F8D@.microsoft.com...
>I have 2 levels of drill down. The first level does expand/collapse. The
> second level, the details, do not get exported unless that section was
> already open in the report. I am using Excel XP.
> Any ideas?
> Thanks.|||If I expand one of the drill downs and then export it then it works fine. I
can use the +/- sign in excel on the second drill down, but if I leave both
collapsed when I export it then I can't.
"Jens Sü�meyer" wrote:
> Normally, even the drill down isn´t checked the data will be exported to
> excel. perhpas you disabled the function in excel for drilling down into the
> data (on the left side there are + and - signs if you have something to
> drill down)
> Unfortunately my Excel on my machine and is asking for the corp.CD which is
> sure don´t have, because I am on the move, so I can´t give you the exact
> menu item to search for, but I gues google and the help file form Excel
> should be your friend.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "scraejtp" <scraejtp@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:10F795EE-7C5C-4A80-9492-607216270F8D@.microsoft.com...
> >I have 2 levels of drill down. The first level does expand/collapse. The
> > second level, the details, do not get exported unless that section was
> > already open in the report. I am using Excel XP.
> > Any ideas?
> > Thanks.
>
>|||I have the same issue and brought it up a month ago, but didn't receive any
responses. I'm not sure what to do about it. I did create a copy of the
report with everything expanded and may link that from my web page, but this
a kludge at best.
Neil
"scraejtp" wrote:
> I have 2 levels of drill down. The first level does expand/collapse. The
> second level, the details, do not get exported unless that section was
> already open in the report. I am using Excel XP.
> Any ideas?
> Thanks.|||Yes, I saw that thread. I actually did a copy/paste of your question because
I am having the exact same problem.
"Neil Gould" wrote:
> I have the same issue and brought it up a month ago, but didn't receive any
> responses. I'm not sure what to do about it. I did create a copy of the
> report with everything expanded and may link that from my web page, but this
> a kludge at best.
> Neil
> "scraejtp" wrote:
> > I have 2 levels of drill down. The first level does expand/collapse. The
> > second level, the details, do not get exported unless that section was
> > already open in the report. I am using Excel XP.
> > Any ideas?
> > Thanks.

Problems exporting from reporting services 2005 to excel with a lot of rows

Hello,

When I export to excel a report made in Reporting Services 2005, and it has a lot of rows in a table (in the detail section), I have to wait a lot of time, and when it finish the size of the file is bigger than the excel file exported from the old reports in crystal report 6. When I open this exported documents, I have to wait more time until I can see them.

The document have 3 sheets, the first have the document map, the second has a report header, and the last one the page header and the body section (with the table). We thought that it could be the document map because it has hyperlinks to the third sheet, but I have tried to delete this sheet in the excel document and the size is more or less the same.

I tried also exporting to CSV but the results aren't what we need.

What could I do?

Anybody can help me? :/|||

Hi ,

I suggest you to align your report items perfectly to the standards of reporting services

what can you notice when the Excel is opened.if you can see unnecessary columns with zero width.then my expectation is right.

if you can see the dots on report layout tab,when you design the report

,make sure that a report item should not end between these two dots

(size should be the multiple of 0.125 inch)

Follow the same for each Report item in the Report and let me know what did you end up with ?

Thank you,

Raj Deep>A

|||

Hi Raj Deep,

Thanks for your response, but my report items are not between any dots, and the size of every textbox is 0.5. The problem must be because there are too many data in the table, I think, but it wasn′t a matter for crystal reports 8. Any other idea? :)

Thank you,

Pablo