Přihlásit
 
HlavníKnihovnaCertifikaceDownloadPodporaKomunitaFóra
Zdroje informací pro profesionály v oboru IT >
> 
> 
Export to excel problem

Odpovědět Export to excel problem

  • 5. ledna 2006 4:05
     
     
    Přihlásit se a hlasovat
    0

    Hi,

    I have a tabular report that has a toggle(collapsible item) in the details area. The toggle works fine in the report designer but when I export it to excel, the toggle is not exported. Are there some properties that I missed configuring?

    Thanks!

     

Všechny reakce

  • 7. ledna 2006 3:35
    Moderátor
     
     Odpovědět
    Přihlásit se a hlasovat
    1

     

    Do you have other table rows between details and the row with the toggle? If this is the case, we cannot generate the outlines in Excel since Excel requires the rows to be consecutive.

    Thank you,

    Nico

     
  • 25. ledna 2006 1:33
     
     
    Přihlásit se a hlasovat
    0

    We had no problem when we use Reporting Services Standard edition. But after we installed Reporting Service SP2, we got the same problem as you. Unfortunately, I don't have solution yet.

    Do you have Reporting Services SP2 installed?

    Please let me know.

    Alison

     
  • 13. července 2007 7:56
     
     
    Přihlásit se a hlasovat
    0
    Did you set the visibility of the table to some expression? If so, just set to visible or hidden, then the toggle will be exported in Excel.
     
  • 13. srpna 2009 9:44
     
     
    Přihlásit se a hlasovat
    0
    Did anyone find a solution to this?

    I have a simple table in my report (RS2005).  I have a details row that has its visibility toggled by a cell in the detail row above (2 details rows in total).  By default the toggle is collapsed and the details are hidden.  But when i export to excel (2003) the talble is fully expanded, with no +/- option, no indentation,  such that it is not even clear that one row is the child of another. 

    Some people have reported having this problem here, and others have said that there's was fine.  Any idea what's goimng on??

    Thanks
    Guy
     
  • 25. března 2012 12:42
     
     
    Přihlásit se a hlasovat
    0

    Though it is an old thread, thought of sharing some useful info for people coming here in future...

    I recently faced this problem. In my case, the problem was that I configured toggling option only on Row's Visibility property. After configuring the same toggling options on each Group's visibility properties, toggling worked perfectly in exported excel file the same way it worked in the report.

    Thanks,

    Harish